Chapter 16: Using SQL Server s XML Support

Overview

XML has become the lingua franca of the Web because it is such an ideal format for exchanging information. Already, many companies exchange information with each other using XML sent over the Web.

In this chapter, you'll learn about SQL Server's extensive support for XML. You'll also see how to store XML in a C# program using the XmlDocument and XmlDataDocument objects.

Featured in this chapter:

• Using the SQL Server FOR XML clause

• Introducing XPath and XSLT

• Accessing SQL Server using HTTP

• Using the SQL Server OPENXML() function

• Using an XmlDocument object to store an XML document

• Using an XmlDataDocument object to store an XML document