Using XML in SQL Server

Support for XML is integrated into all the components in SQL Server and includes the following:

  • Support for the xml data type.
  • The ability to specify an XQuery query against XML data stored in columns and variables of the xml type.
  • Enhancements to OPENROWSET to allow bulk loading of XML data.
  • Enhancements to the FOR XML clause and OPENXML function introduced in SQL Server 2000.

In This Section

Topic Description

xml Data Type Representation in the AdventureWorks Database

Describes xml type columns in the AdventureWorks database. Queries against xml data type in various topics are specified against these columns.

xml Data Type

Describes xml data type, concept of typed versus untyped xml, and various methods of xml data type.

Indexes on xml Data Type Columns

Describes primary and secondary XML indexes on the xml type.

Managing XML Schema Collections on the Server

Describes the concept of the XML schema collection, the DDL to create, modify, or drop the collection, and how to use it in creating typed xml columns and variables.

Using FOR XML and OPENXML to Publish and Process XML Data

Describes the FOR XML clause to use with the SELECT statement to construct XML from relational data and OPENXML, and which you can use to query and shred XML into a rowset.

For information about client-side XML functionality, see SQLXML 4.0 Programming.

For information about XQuery support in the Microsoft .NET Framework, see the topic "XML Querying and SQL Server XML Support" in the .NET Framework documentation.

See Also


Sample XML Applications
Examples of Bulk Importing and Exporting XML Documents

Help and Information

Getting SQL Server 2005 Assistance