Collections:
Underflow and Overflow of FLOAT Values in SQL Server Transact-SQL
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL?
✍: FYIcenter.com
If you enter a floating number that is too big or too small for the FLOAT data type, Transact-SQL will behave as:
Tutorial exercises below show some good underflow and overflow examples:
-- Single precision underflow without warning DECLARE @x REAL; -- FLOAT(24) SET @x = 9.234568E-39; SELECT @x; ---------------------------------- 0 -- Single precision overflow error DECLARE @x REAL; -- FLOAT(24) SET @x = 9.234568E+39; ---------------------------------- Msg 232, Level 16, State 2, Line 2 Arithmetic overflow error for type real, value = 9234568000000000400000000000000000000000.000000. -- Double precision underflow with warning DECLARE @x FLOAT(53); SET @x = 9.23456789012346E-309 SELECT @x; ---------------------------------- Warning: the floating point value '9.23456789012346E-309' is too small. It will be interpreted as 0. 0 -- Double precision overflow error DECLARE @x FLOAT(53); SET @x = 9.23456789012346E+309 ---------------------------------- Msg 168, Level 15, State 1, Line 2 The floating point value '9.23456789012346E+309' is out of the range of computer representation (8 bytes).
⇒ Differences of DECIMAL and FLOAT in SQL Server
⇐ Precision and Rounding of FLOAT Values in SQL Server Transact-SQL
2017-04-19, 6602🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...