Transact-SQL Desk Reference

2.4. SQL SERVER 2K DATA TYPES

SQL Server supports a wide variety of native data types which may be used for column data type in a CREATE TABLE statement and for local variables and function return types. Virtually all SQL-92 data types are supported as well as a few additional ones as shown in Table 2-15.

Table 2-15. Data Types

T-SQL Data Type Name	SQL-92	General Comments Each type is described individually in the following sections.
BIGINT
BINARY		SQL-92 has BLOB (binary large object)
BIT	Yes	SQL-92 has a different BIT data type.
CHAR	Yes
DATETIME		SQL-92 has DATE and TIME
DECIMAL	Yes
FLOAT	Yes
IMAGE		SQL-92 has BLOB (binary large object)
INT	Yes
MONEY
NCHAR	Yes
NTEXT
NVARCHAR	Yes
NUMERIC	Yes
REAL	Yes
SMALLDATETIME
SMALLINT	Yes
SMALLMONEY
SQL_VARIANT
SYSNAME ...