Export (0) Print
Expand All
2 out of 12 rated this helpful - Rate this topic

Transact-SQL Data Types

SQL Server 2005

Microsoft SQL Server 2005 introduces a new data type and has enhanced several of the existing SQL Server data types.

Data type Description

xml

Used to store XML data.

Data types Description

varchar(max)

Indicates that the maximum storage size for the varchar data type is 2^31-1 bytes.

nvarchar(max)

Indicates that the maximum storage size for the nvarchar data type is 2^31-1 bytes.

varbinary(max)

Indicates that the maximum storage size for the varbinary data type is 2^31-1 bytes.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.