Saturday, February 09, 2008

SQL Server 2005 Large Data Values

SQL Server 2005 has some new data types, specifically designed to replace the older data types for storing large values. These would be varchar(max), nvarchar(max) and varbinary(max). These data types are meant to replace the older text, ntext and image column data types.

This article descibes enabling large values to in a table with a column that has data that is larger than 8K. A good example of this is a large XML File.
http://technet.microsoft.com/en-us/library/ms173530.aspx

This article explains the different large data types.
http://technet.microsoft.com/en-us/library/ms178158.aspx

No comments: