Exact numeric datatypes

tinyint

0 to 255

1

smallint

-2¹⁵ (-32,768) to 2¹⁵ -1 (32,767)

2

int

integer

-2³¹ (-2,147,483,648) to 2³¹ -1 (2,147,483,647)

4

numeric (p, s)

-10³⁸ to 10³⁸ -1

2 to 17

decimal (p, s)

dec

-10³⁸ to 10³⁸ -1

2 to 17

Approximate numeric datatypes

float (precision)

Machine dependent

4 or 8

double precision

Machine dependent

8

real

Machine dependent

4

Money datatypes

smallmoney

-214,748.3648 to 214,748.3647

4

money

-922,337,203,685,477.5808 to 922,337,203,685,477.5807

8

Date/time datatypes

smalldatetime

January 1, 1900 to June 6, 2079

4

datetime

January 1, 1753 to December 31, 9999

8

date

January 1 0001 to December 31, 9999

8

time

00:00:00:000 to 23:59:59:999

4

Character datatypes

char(n)

character

Determined by your server's logical page size

n

varchar(n)

char[acter] varying

Determined by your server's logical page size

actual entry length

unichar

Unicode character

Determined by your server's logical page size

n*@@unicharsize (@@unicharsize equals 2)

univarchar

Unicode character varying

Determined by your server's logical page size

actual number of characters *@@unicharsize

nchar(n)

national char[acter]

Determined by your server's logical page size

n * @@ncharsize

nvarchar(n)

nchar varying, national char[acter] varying

Determined by your server's logical page size

n

Binary datatypes

binary(n)

Determined by your server's logical page size

n

varbinary(n)

Determined by your server's logical page size

actual entry length

Bit datatype

bit

0 or 1

1 (1 byte holds up to 8 bit columns)

Text and image datatypes

text

2³¹ -1 (2,147,483,647) bytes or fewer

0 until initialized, then a multiple of the logical page size

image

2³¹ -1 (2,147,483,647) bytes or fewer

0 until initialized, then a multiple of the logical page size