Chapter 13. XML and XQuery
Dejan Sarka
SQL Server 2008 includes extensive support for XML. This support includes creating XML from relational data with a query and shredding XML into relational tabular format. Additionally, SQL Server 2008 has a native XML data type. You can store XML data, constrain it with XML schemas, index it with specialized XML indexes, and manipulate it using data type methods. All of T-SQL’s XML data type methods accept an XQuery string as a parameter. XQuery (for XML Query Language) is the standard language used to query and manipulate XML data. The implementation of XQuery in SQL Server 2008 follows the World Wide Web Consortium (W3C) standard, and it is supplemented with extensions to support data modifications. You ...
Get Inside Microsoft® SQL Server® 2008: T-SQL Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
