Size limit of XML variable in SQL Server 2008 大小2G

Size limit of XML variable in SQL Server 2008

Yes it is the same as I read this. http://msdn.microsoft.com/en-us/library/ms187339.aspx

You can store xml instances in a column, or a variable of xml type

and

The stored representation of xml data type instances cannot exceed 2 gigabytes (GB) in size.

Highlights is done by me.

Update The limit is the same for 64-bit OS.

 

 

 

 

作者:Chuck Lu    GitHub