Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |
|---|---|
Used to store XML data. |
Enhanced Data Types
| Data types | Description |
|---|---|
Indicates that the maximum storage size for the varchar data type is 2^31-1 bytes. |
|
Indicates that the maximum storage size for the nvarchar data type is 2^31-1 bytes. |
|
Indicates that the maximum storage size for the varbinary data type is 2^31-1 bytes. |
See Also
Reference
Other Resources
What's New and Enhanced in Transact-SQL (Transact-SQL)