All Sql DataType
bigint
Integer data from -2^63 through 2^63-1
binary
Fixed-length binary data with a maximum length of 8,000 bytes
bit
Integer data with either a 1 or 0 value
char
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
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
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
nvarchar
Variable-length Unicode data with a maximum length of 4,000 characters
numeric
Fixed precision and scale numeric data from -10^38 +1 through 10^38 -1
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
sysname
text
Variable-length data with a maximum length of 2^31 - 1 characters
timestamp
tinyint
Integer data from 0 through 255
varbinary
Variable-length binary data with a maximum length of 8,000 bytes
varchar
Variable-length data with a maximum of 8,000 characters
uniqueidentifier
A globally unique identifier
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment