Untitled Page

bigint -- Integer data from -2^63 through 2^63-1
binary(50) -- Fixed-length binary data with a maximum length of 8,000 bytes
bit -- Integer data with either a 1 or 0 value
char(10) -- Fixed-length character data with a maximum length of 8,000 characters
datetime -- Date and time data from January 1, 1753, through December 31, 9999,
with an accuracy of 3.33 milliseconds
decimal(18,0) -- Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1
float -- Floating precision number data from -1.79E + 308 through 1.79E + 308
image -- Variable-length binary data with a maximum length of 2^31 - 1 bytes
Int -- Integer data from -2^31 through 2^31 - 1
money -- Monetary data values from -2^63 through 2^63 - 1
nchar(10) Fixed-length Unicode data with a maximum length of 4,000 characters
ntext -- Variable-length Unicode data with a maximum length of 2^30 - 1 characters
numeric(18,0) -- Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1
nvarchar(50) -- Variable-length Unicode data with a maximum length of 4,000 characters
nvarchar(MAX)-- Variable-length Unicode data with a maximum length of 4,000 characters
real -- Floating precision number data from -3.40E + 38 through 3.40E + 38
smalldatetime -- Date and time data from January 1, 1900, through June 6, 2079,
with an accuracy of one minute
smallint -- Integer data from -2^15 through 2^15 - 1
smallmoney -- Monetary data values from -214,748.3648 through +214,748.3647
sql_varient -- A data type that stores values of various data types, except text, ntext, timestamp, and sql_variant
text -- Variable-length data with a maximum length of 2^31 - 1 characters
timestamp -- A database-wide unique number that gets updated every time
a row gets updated
tinyint-- Integer data from 0 through 255
unique indentifier
varbinary(50) -- Variable-length binary data with a maximum length of 8,000 bytes
varbinary(MAX) -- Variable-length binary data with a maximum length of 8,000 bytes
varchar(50) Variable-length data with a maximum of 8,000 characters
varchar(MAX) Variable-length data with a maximum of 8,000 characters
xml

Martin Lee

My Personal Site