What’s New in Using XML in SQL Server 2008

XML and relational data may exist side by side and are more interchangeable than ever, thanks to SQL Server’s XML-centric features, such as the xml data type, extensions to FOR XML, schema storage, content validation, indexing, XQuery support, and more.

With the release of SQL Server 2008, the SQL Server team added support for the few XML features that were unavailable in SQL Server 2005, including

• Support for lax validation in XML schemas

• Improved support for union and list types in XML schemas

• Addition of the let clause in XQuery

• Enhancements to XML Data Modification Language (DML) expressions

The introduction of these features is both vital and timely because XML has become the standard ...

Get Microsoft® SQL Server 2008 R2 Unleashed 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.