## Microsoft SQL Database – Data Types Reference List

The following data types are associated with Microsoft’s SQL database.

Article Source: http://msdn.microsoft.com/en-us/library/aa258271(SQL.80).aspx

### Exact Numerics

*Integers*

**bigint**

Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808) through 2^63-1 (9,223,372,036,854,775,807).

**int**

Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 – 1 (2,147,483,647).

**smallint**

Integer data from -2^15 (-32,768) through 2^15 – 1 (32,767).

**tinyint**

Integer data from 0 through 255.

*bit*

**bit**

Integer data with either a 1 or 0 value.

*decimal and numeric*

**decimal**

Fixed precision and scale numeric data ...

MAY

2011