Microsoft® SQL Server 2005 Unleashed

Chapter 37. Using XML in SQL Server 2005

IN THIS CHAPTER

• What’s New in Using XML in SQL Server 2005

• Understanding XML

• Relational Data as XML: The FOR XML Modes

• XML as Relational Data: Using OPENXML

• Using the New xml Data Type

• Indexing and Full-Text Indexing of xml Columns

SQL Server first planted its Extensible Markup Language (XML) roots with the introduction of the FOR XML and OPENXML keywords in SQL Server 2000, right around the time XML was growing in popularity as a markup format with seemingly unlimited uses.

With the release of SQL Server 2005, the bar has clearly been raised for XML support in relational databases.

What’s New in Using XML in SQL Server 2005

XML and relational data may coexist side-by-side and are more interchangeable than ever, ...