Chapter 11. SQL Server XML frequently asked questions

Michael Coles

With the SQL Server 2005 release, Microsoft implemented new and exciting XML integration into SQL Server. These features include the following:

  • A new native xml data type
  • XML content indexing
  • Improvements to the FOR XML clause
  • Improvements to the OPENROWSET function
  • Integrated support for XML Schema
  • Native XQuery (XML Query Language) support
  • Access to additional XML-specific functionality via SQL CLR integration

All of this functionality, with some additional improvements, is included in SQL Server 2008. Many developers have questions about how to take advantage of this new functionality. This chapter is structured in a frequently-asked-questions (FAQ) format, and will ...

Get SQL Server MVP Deep Dives 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.