Top "Sqlxml" questions

How to query for Xml values and attributes from table in SQL Server?

I have a table that contains a Xml column: SELECT * FROM Sqm A sample of the xml data of a …

sql-server xml sql-server-2005 sql-server-2008-r2 sqlxml

How to query values from xml nodes?

i have a table that contains an XML column: CREATE TABLE Batches( BatchID int, RawXml xml ) The xml contains items …

sql-server sql-server-2005 xpath sqlxml

SQL multiple SELECT query with xmlagg function- Data not pulled in the required fashion

My data in Oracle is something like this NAME | DEP_VALUE | ID_DEP Amy 1 AA1234 Bob 2 BB4321 Clara 1 CC5678 Clara 2 …

sql oracle select grouping sqlxml

SQL Server - returning xml child nodes for xml column

Given table T with columns: ID UNIQUEIDENTIFIER CreatedDate DATETIME XmlData XML Where XmlData is structured like: <application> <…

sql sql-server xml sqlxml

XML output from MySQL

is there any chance of getting the output from a MySQL query directly to XML? Im referring to something like …

mysql xml database sqlxml

XML Schema Error: Required white space was missing

I have been searching on this for hours and can not figure out the issue. Could someone please help me …

xml xsd vb.net-2010 sqlxml bulk-load

Creating XML with SQL Server

I have a table with the data: itemID itemLocation quantity ------------------------------------------------------- B008KZK44E COMMITED 1 B008KZK44E PRIME 1 B008…

sql sql-server xml tsql sqlxml

SQL UNION FOR XML name output column

I'm trying to generate an XML output from SQL and need to use a UNION statement and also name the …

sql-server sql-server-2008 tsql sqlxml

SQL : Find if XML node exists

Assuming I have a table data as below: I want to Select all Value(XML Data) which contains the node …

sql sql-server tsql sqlxml

How to return XML from SQL Server 2008 that is structured with multiple selections sharing a common parent

I've tried using "FOR XML PATH", "FOR XML EXPLICIT" and "FOR XML AUTO" but the data is never structured with …

sql sql-server xml sql-server-2008 sqlxml