Chapter 12. XQuery and XPath

As I described in Chapter 11, SQL Server 2008 continues the high level of XML integration begun in SQL Server 2005. As part of that integration, SQL Server's xml data type provides builtin functionality for shredding XML data into relational format, querying XML nodes and singleton atomic values via XQuery, and modifying XML data via XML Data Modification Language (XML DML). This chapter focuses on how to get the most out of SQL Server's implementation of the powerful and flexible XPath and XQuery standards.

The XML data model represents a departure from the relational model SQL Server developers know so well. XML is not a replacement for the relational model, but it does nicely complement relational data. XML is very ...

Get Pro T-SQL 2008 Programmer's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.