int, bigint, smallint, and tinyint in SQL Server

Published on Tuesday, September 7, 2010

The following content copied from Microsoft:

SQL Server 2000

Exact number data types that use integer data.

bigint

Integer (whole number) data from -263 (-9,223,372,036,854,775,808) through 263-1 (9,223,372,036,854,775,807). Storage size is 8 bytes.

int

Integer (whole number) data from -231 (-2,147,483,648) through 231 - 1 (2,147,483,647). Storage size is 4 bytes. The SQL-92 synonym for int is integer.

smallint

Integer data from -215 (-32,768) through 215 - 1 (32,767). Storage size is 2 bytes.

tinyint

Integer data from 0 through 255. Storage size is 1 byte.