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 Language Reference (Database Engine).