sql datatypes

SQL Server2000 DataTypes

bigint
binary
bit
char
datetime
decimal
float
image
int
money
nchar
ntext
numeric
nvarchar
real
smalldatetime
smallint
smallmoney
sql_variant
text
timestamp
tinyint
uniqueidentifier
varbinary
varchar

SQL Server2005 DataTypes

bigint
binary(50)
bit
char(10)
datetime
decimal(18,0)
float
image
int
money
nchar(10)
ntext
numeric(18,0)
nvarchar(50)
nvarchar(MAX)
real
smalldatetime
smallint
smallmoney
sql_variant
text
timpstamp
tinyint
uniqueidentifier
varbinary(50)
varbinary(MAX)
varchar(50)
varchar(MAX)
xml