Table 1-5 lists the ANSI SQL standards and compliance levels for Transact-SQL datatypes.
Transact-SQL – ANSI SQL datatypes
Transact-SQL extensions – User-defined datatypes
char
varchar
smallint
int
bigint
decimal
numeric
float
real
date
time
double precision
binary
varbinary
bit
nchar
datetime
smalldatetime
bigdatetime
bigtime
tinyint
unsigned smallint
unsigned int
unsigned bigint
money
smallmoney
text
unitext
image
nvarchar
unichar
univarchar
sysname
longsysname
timestamp