Transact-SQL Data Types

  • Article

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

New Data Types

Data type Description

xml

Used to store XML data.

Enhanced Data Types

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.

See Also

Reference

Data Types (Transact-SQL)

Other Resources

What's New and Enhanced in Transact-SQL (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance