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, 1437🔥, 0💬
Popular Posts:
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...