SQL Data Type Reference

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 ...

Read more →
0