Using the XML Extender , you can retrieve either an entire document or the contents of elements and attributes. When you retrieve an XML column directly, the XML Extender returns the UDT as the column type.
Read More - Register for Free Membership
