SQL Server 2008 R2——Data Types

SQL Server provides data type synonyms for ISO compatibility. For more information, see Data Type Synonyms (Transact-SQL).

Data Type Categories

Data types in SQL Server are organized into the following categories:

In SQL Server, based on their storage characteristics, some data types are designated as belonging to the following groups:

• Large value data types: varchar(max), nvarchar(max), and varbinary(max)

• Large object data types: text, ntext, image, varchar(max), nvarchar(max), varbinary(max), and xml

  Note
  sp_help returns -1 as the length for the large-value and xml data types.

Exact Numerics

Approximate Numerics

Date and Time

Character Strings

Unicode Character Strings

Binary Strings

Other Data Types

SQL Server 2008 R2——Data Types

标签：