Approximate Numeric Data Types in SQL Server Transact-SQL
What are approximate numeric data types supported in SQL Server Transact-SQL?
Approximate numeric data types are used to hold numeric values with floating scales.
There are 3 different approximate numeric data types supported in SQL Server Transact-SQL:
1. FLOAT - Used to hold values with different precisions and floating scales specified in the format of FLOAT(p), where p is the precision presenting the number of bits used to store the mantissa part. For example, FLOAT(12) stores floating numbers with a 12-bit mantissa.
2. DOUBLE PRECISION - Use to hold values with a large precision and floating scales using 8-byte storage to store floating numbers in the ranges of -1.79E+308 to -2.23E-308, 0 and 2.23E-308 to 1.79E+308. DOUBLE PRECISION is identical to FLOAT(53).
3. REAL - Use to hold values with a normal precision and floating scales using 4-byte storages to store floating numbers in the ranges of -3.40E+38 to -1.18E-38, 0 and 1.18E-38 to 3.40E+38.
Here are some good examples of approximate numeric values:
PRINT 9.22337203685e+010; -- FLOAT(53) PRINT 9.22337e+010; -- FLOAT(24)
2017-04-19, 1085👍, 0💬
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...