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, 257👍, 0💬
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedu...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...