Using XML Data
You can create variables and columns of xml data type. The xml data type has its own methods. For more information see, xml Data Type Methods.
You can specify XQuery against the XML data stored in a column or a variable of xml data type. For more information see, XQuery Against the xml Data Type.
See Also
Other Resources
CAST and CONVERT (Transact-SQL)