*bigint,BIGINT,-1
*smallint,SMALLINT,-1
*tinyint,SMALLINT,-1
*int,INTEGER,-1
*money,DECIMAL,-1
*datetime,TIMESTAMP,-1
*date,date,-1
char*,CHARACTER,-1
nchar*,CHARACTER,-1
text*,VARCHAR,2147483647
ntext*,VARCHAR,1073741823
varchar*,VARCHAR,-1
nvarchar*,VARCHAR,-1
binary*,BINARY,-1
varbinary*,VARBINARY,-1
image*,LONGVARBINARY,-1
timestamp*,VARCHAR,100
time*,TIME,-1
hierarchyid,VARBINARY,-1
uniqueidentifier,VARCHAR,250
xml,VARCHAR,2147483647
geography,VARCHAR,250
*float,FLOAT,-1
*double,DOUBLE,-1
decimal*,DECIMAL,-1
numeric*,DECIMAL,-1
bit,SMALLINT,-1