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, 6683🔥, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...