May 18
XML Shredding in SQL Server 2005
XML Shredding in SQL Server 2005
I've written a short tutorial on shedding xml with SQL Server 2005.
SQL Server 2005 does a pretty good job at mixing and matching relational and xml data. One of the things you sometimes want to do with an xml document is to shred it into tables. Shredding into tables is the process of extracting the data from an xml document and inserting it into one or more tables, and using FOREIGN KEY's to represent any parent/child relationships that exist in the xml document
This paper is about the new shredding capability of T-SQL. The sources for all of the examples shown accompany this paper. It's available at via the link on the title at beginning of this entry.
www.sqlservicebroker.com