Collections:
Overflow Errors with INT Values in SQL Server Transact-SQL
What Happens If an Integer Is Too Big for INT (INTEGER) Date Type in SQL Server Transact-SQL?
✍: FYIcenter.com
If you are entering an INT data type literal with representing an integer value too big for INT data type to store, the SQL Server will give you an arithmetic overflow error. The same error will happen on BIGINT, INT, SMALLINT, and TINYINT data types.
Remember that INT data types uses 4 bytes to an integer value between -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647). The tutorial exercise below gives an example of arithmetic overflow errors.
-- INT value in the range DECLARE @x INT; SET @x = 2147483647; SELECT @x; ---------- 2147483647 -- INT value overflow DECLARE @x INT; SET @x = 2147483648; ----------------------------------- Msg 8115, Level 16, State 2, Line 2 Arithmetic overflow error converting expression to data type int.
2017-04-19, 833👍, 0💬
Popular Posts:
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...