SQLXML is a feature in MS SQL (introduced in SQL Server 2000), that enables XML support for making queries and processing data.
I'm having issues querying XML data stored in a SQL Server 2012 database. The node tree I wish to query is …
sql xml sql-server-2012 sqlxmlI want to concatenate multiple rows in one column. I found many examples in Internet but does not working for …
sql-server xml path concatenation sqlxmlI'm using SQL Server 2008's XML-parsing abilities to iterate through an XML document and perform an INSERT each element. However, …
sql xml sql-server-2008 sqlxmlI have the following XML: <root> <row value="US"> <col value="00">Jon</col&…
sql-server sql-server-2008 tsql cross-apply sqlxmlUsing SQL 2012 & getting XML passed into a stored procedure that must take that input & write a row to …
sql sql-server xml tsql sqlxmlI have a table of hierarchical data that I am trying to select as a single, grouped XML value: Columns: …
sql sql-server-2008 sqlxmlI have an xml column called OrderXML in an Orders table... there is an XML XPath like this in the …
sql-server tsql xpath-2.0 sqlxml xml-columnHow can I insert a whole bunch of rows into an XML variable without using a cursor? I know I …
sql-server-2005 sqlxmlI have two tables, XMLtable and filterTable. I need all the XMLtable.ID values from XMLtable where the data in …
sql-server xml tsql xpath sqlxml