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, 3175🔥, 0💬
Popular Posts:
How To Concatenate Two Binary Strings Together in SQL Server Transact-SQL? SQL Server 2005 allows to...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How to obtain the version number of the ICU (International Components for Unicode) library using the...