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.
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.
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 |
|
Download e-Book 
Copyright © 2010 data-e-education.com. All rights reserved.
