O'Reilly logo

SQL Server MVP Deep Dives by Greg Low, Paul Randal, Kimberly Tripp, Adam Machanic, Kalen Delaney, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required