SQL - Structured Query Language

Numeric Data Types

Data Type is an attribute that defines type of data of an object in the SQL Server. Each Table Column, Program Variable, Expression and Parameter must be defines with unique data types to optimize database operation in the SQL Server.

SQL Server deployed with Exact Numerics, Approximate, Numerics, Data and Time, Character Strings, Unicode Character String, Binary Strings and Other System Data Types. SQL Server can deploy with Alias Data Types that are based on the system supplied data types. SQL Server can deploy with User Defined Data Types that can form and execute through .NET Programming Language.

Exact Numerics
Data Type	Range	Storage
bigint	-2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)	8 Bytes
bit	TRUE or FALSE convert into 0 or 1 8 or less bit columns 9 or less 16 bit columns	1 Byte 1 Byte 2 Bytes
int	-2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)	4 Bytes
money	-922,337,203,685,477.5808 to 922,337,203,685,477.5807	8 Bytes
numeric	Precision 1 - 9 Precision 10 ? 19 Precision 20 ? 28 Precision 29 ? 38	5 Bytes 9 Bytes 13 Bytes 17 Bytes
decimal	Precision 1 - 9 Precision 10 ? 19 Precision 20 ? 28 Precision 29 ? 38	5 Bytes 9 Bytes 13 Bytes 17 Bytes
smallint	-2^15 (-32,768) to 2^15-1 (32,767)	2 Bytes
smallmoney	- 214,748.3648 to 214,748.3647	4 Bytes
tinyint	0 to 255	1 Byte

Note:

Numeric data types have fixed precision and scale. According to the Precision the Storage varies. Precision is a maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point.

The precision must be a value from 1 to 38. The default precision is 18. Scale is a maximum number of decimal digits that can be stored to the right of the decimal point. The scale must be a value from 0 to P. Maximum storage sizes vary, based on the precision.

Approximate Numerics
Data Type	Range	Storage
float	- 1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308	Value of n Bytes
real	- 3.40E + 38 to -1.18E - 38, 0 and 1.18E - 38 to 3.40E + 38	4 Bytes

* * * * *

Your Comment To AUTHOR