Category: SQL Server
view more software Tips and Tricks
Updated: 10/05/2011 10:10 AM
Author: Shiju Mathews
Is the data type that stores XML data. You can store xml instances in a column, or a variable of xml type.
Restricts the xml instance to be a well-formed XML document. The XML data must have one and only one root element. Text nodes are not allowed at the top level.
The stored representation of xml data type instances cannot exceed 2 gigabytes (GB) in size.