The following Microsoft SQL Server 2008 T-SQL data types can be used in TABLE declaration and variable/parameter definition:

-- SQL Server 2008 T-SQL data types
bigint
bit
char                    -- char(10)
date
datetime
decimal                 -- decimal(10,2)
float
geography
geometry               
hierarchyid
image
int
money
nchar                   -- nchar(10)
ntext
numeric                 -- numeric(12,2)
nvarchar                -- nvarchar(32), nvarchar(max)
real
rowversion
smallint
smallmoney
text
time
tinyint
uniqueidentifier
varbinary               -- varbinary(10), varbinary(max)
varchar                 -- varchar(64), varchar(max)
xml