SQL Server DataType

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