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