Home / Software / Tips and Tricks / xml datatype in SQL server

xml datatype in SQL server

Updated:  10/05/2011 10:10 AM
Author:  Shiju Mathews

Status:    Resolved.


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.