Collections:
Overflow Errors on Converting Big Values to Integers in SQL Server
What Happens When Converting Big Values to Integers in SQL Server Transact-SQL?
✍: FYIcenter.com
If you are converting a numeric expression to an integer data type and the value is too big for integer storage size, you will get an arithmetic overflow error as shown in the following examples:
-- Overflow error on implicit conversion DECLARE @x FLOAT(24); DECLARE @y TINYINT; SET @x = 12345.12E+00; SET @y = @x; GO Msg 232, Level 16, State 1, Line 4 Arithmetic overflow error for type tinyint, value = 12345.120117. -- Overflow error on explicit conversions DECLARE @x FLOAT(24); SET @x = 12345.12E+00; SELECT CAST(@x AS TINYINT); SELECT CONVERT(TINYINT, @x); GO Msg 232, Level 16, State 1, Line 4 Arithmetic overflow error for type tinyint, value = 12345.120117. Msg 232, Level 16, State 1, Line 5 Arithmetic overflow error for type tinyint, value = 12345.120117.
⇒ Overflow Errors on Converting Big Values to NUMERIC in SQL Server
⇐ CONVERT() - Converting Character Strings to Numeric Values in SQL Server
⇑ Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-22, 1520🔥, 0💬
Popular Posts:
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...