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 |
|---|---|
Describes xml type columns in the AdventureWorks database. Queries against xml data type in various topics are specified against these columns. |
|
Describes xml data type, concept of typed versus untyped xml, and various methods of xml data type. |
|
Describes primary and secondary XML indexes on the xml type. |
|
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. |
|
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
Concepts
Sample XML Applications
Examples of Bulk Importing and Exporting XML Documents