Sql server data types 2012
Sql-Server 2012 has following data types
| data types | name |
Data Type
|
Values
|
tinyint
|
1 byte values 0-255
|
Smallint
|
2 bytes values -32768 to 32767
|
int
|
4 bytes values -2147483648 to 2147483647
|
bigint
|
8 bytes values -9223372036854775808 to 9223372036854775807
|
float
|
|
real
|
|
Binary
|
|
varbinary
|
|
Char
|
|
Varchar
|
|
bit
|
|
Smallmoney
|
|
money
|
|
Numeric
|
|
Date
|
|
SmallDatetime
|
|
Datetime
|
|
TimeStamp
|
|
Time(7)
|
|
DateTime2
|
|
DateTimeOffSet
|
|
image
|
|
Hierarchyid
|
|
Sql_variant
|
|
xml
|
|
Uniqueidentifier
|
