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.