OpenXML options explained: rowpattern recursion to search lower levels of your XML, and column patterns to reach one level higher, with a manager example.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Preparing XML in Memory – Day 34 of 35
Before you can turn XML into a result set, SQL Server needs it in memory. Here is how preparing XML in memory works, with a customer order example.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Shredding XML – Day 33 of 35
After streaming table data into XML, we go the other way. Shredding XML means turning XML data back into rows and columns that you can query.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 32 of 35
Beyond using root with Auto XML mode, the XML Path mode lets you show some data as attributes and some as elements. Here is how, with JProCo data.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 31 of 35
Add a root element to the Auto XML mode so your XML stream is well-formed, and give the root node a meaningful name with the ROOT keyword.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML Day 30 of 35
In What is XML Day 30, we use FOR XML RAW to output the Employee table as XML, then add ROOT to get a root node and well-formed XML.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML? – Day 29 of 35
What is XML? A simple look at XML files as text documents, how they show the structure of your data and how to read well-formed XML at a glance.