Stack Overflow
Stack Overflow

Questions tagged [sqlxml]

SQLXML is a feature in MS SQL (introduced in SQL Server 2000), that enables XML support for making queries and processing data.

SQLXML was introduced in MS SQL Server 2000, and adds support for MSXML library into SQL Server. It allows the user to execute SQL SELECT statements that return XML instead of tabular data. In later versions(from SQL Server 2005), the XML support was extended with adding xml as a type in MS SQL Server to support XPath and XQuery over tables.

More info can be found in SQLXML's page in MSDN: http://msdn.microsoft.com/en-us/library/aa286527.aspx

471 questions
0
votes
1 answer

Copy attributes from source "table"

I am trying to modify a chunk of xml and insert extra information without altering the original info. Given an xml document such as the following: I want to achieve the following…
DJL
  • 2,060
  • 3
  • 20
  • 39
0
votes
2 answers

FOR XML multiple control by attribute in tree concept

I want to figure out one issue. I already had question about simple ordering issue but I want to order more detail. check below this link : SQL Server : FOR XML sorting control by attribute I made a example case. SQL Query. select ( select…
clear.choi
  • 835
  • 2
  • 6
  • 19
0
votes
1 answer

Why is this stored procedure only inserting one item?

Okay, so, I'm very new to SQL Server 2008 But my mission is to create a procedure that will simply load in some XML file from somewhere and parse its name and data into a single two-column table. Here's a general idea of what the contents of a given…
user3042783
  • 41
  • 7
0
votes
1 answer

How to parse XML in TSQL

I'm getting xml in SQL Server, and I need to get businessDate value I tried this Select C.value('(businessDate)[1]', 'DATETIME') AS FROM @input.nodes('/MealsUsed/*') AS T(C) xml:
Gary
  • 9
  • 1
0
votes
2 answers

How to access XML-Node above cursor in stored procedure?

I'm trying to import an xml-file via a a stored procedure into a MSSQL 2012 server. As you can see in the xml-file it consists out of couple of nodes which I want to import into the tables: production_orders - whereas one xml file is represented by…
Nikel Weis
  • 724
  • 10
  • 27
0
votes
1 answer

MSSQL XML max function returns null

In my transaction table, I have an XML column which contains some additional information about the transaction, e.g. how some prices in the transaction were calculated (for the publisher side and the seller side). Since the calculation algorithm may…
fero
  • 6,050
  • 1
  • 33
  • 56
0
votes
1 answer

XML tag formation using sql query

My Xml Looks like this: biometrictDate, biometricID,dateOfBirth, firstName, gender, lastName, consumerUserId, MedicalHeightValue are all columns from a table.
Poornima
  • 11
  • 1
0
votes
3 answers

Extract xml from another xml using OpenXML

I have an xml, for example: "…
Inbal
  • 909
  • 2
  • 28
  • 46
0
votes
2 answers

Search and Replace on values in an XML column: Error on value with space in value

I tried what was recomended on this thread: Can I do a find/replace in t-sql? UPDATE xmlTable SET xmlCol = REPLACE( CAST( xmlCol as varchar(max) ), '[search]', '[replace]') So I tried it and it worked, sometimes. For example the following would…
jsefton007
  • 1
  • 2
0
votes
2 answers

XML value update in SQL SERVER

Can someone help with the this table please, I want to change the page size value from 25 to 5000? Select input_xml From create_report Where report_name='test report'; The above query this data input_xml
Wood Chipper
  • 5
  • 3
0
votes
1 answer

Equivalent of SQLXML Bulk Load in PostgreSQL

Is there an equivalent of Microsoft .Net's SQLXML Bulk Load (http://msdn.microsoft.com/en-us/library/ms171878.aspx) for Postgresql/PostGIS that I can run on linux? I have a huge and complicated XML file I'd like to import into PostGIS on a linux…
Patrick64
  • 430
  • 6
  • 12
0
votes
1 answer

T-SQL: import xml with variable elements

I have a xml File, which has a strucure like this: 7654321 qwer asdf I want to import…
user2769104
  • 1
  • 1
0
votes
1 answer

Tool to create SQLXMLBulkLoad Schemas?

SQLXMLBulkLoad requires schemas to be annotated with various attributes (e.g. sql:datatype) and some additional elements. Is there any tool that can enrich a schema with this information for at least some basic scenarios?
Frank de Groot - Schouten
  • 182
  • 1
  • 11
0
votes
1 answer

Storing Date Time in an XML column - XML format vs SQL Format

I have a stored procedure, which has the parameters OrderID (bigint) and ApprovalDateTime(varchar(25)) The SP simply updates an XML column called UserDef with the following XML for a given OrderID: 01/01/2013…
FMFF
  • 1,652
  • 4
  • 32
  • 62
1 2 3
…
31 32