SQL Tutorial: Numeric Data Types

The numeric data types described in below Table

Data Type From To Storage size
bigint -9,223,372,036,854,775,808 9,223,372,036,854,775,807 8 bytes
int -2,147,483,648 2,147,483,647 4 bytes
smallint -32,768 32,767 2 bytes
tinyint 0 255 1 byte
bit 0 1 1 byte
decimal -10^38 +1 10^38 -1 5 to 17 bytes
numeric -10^38 +1 10^38 -1 5 to 17 bytes
money -922,337,203,685,477.5808 +922,337,203,685,477.5807 8 bytes
smallmoney -214,748.3648 +214,748.3647 4 bytes

For example: Product table with numeric data types (int, money, smallint, bit)

product table