From the course: Microsoft SQL Server 2016 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Shred XML - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
Shred XML
- [Instructor] Now we'll look at using SQL Server 2016 to convert XML data into data stored in columns and rows. This process is sometimes called shredding XML, so we shred XML into a tabular format. In other words, something that looks like a table. I've staged some code for you for this. I'll copy and paste all of that into a new query window. At the top, there's two lines that declare variables. The variable rawXML will be used to hold the unprocessed XML. Then the variable XML inMemory will be used to hold the formatted data in memory after it's been shredded. I then have some lines where I'm creating some XML. I just have the XML inline in the script. This also could read XML from a file, read XML from a table, or use just about any other source of XML. Then I'm going to call a stored procedure that's built-in. It's called sp_xml_preparedocument. It takes one input, and that is the rawXML and produces one output, and that is the formatted information in memory. So once this line…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.