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