Arithmetic overflow error

Question

I'm getting:

Msg 8115 Arithmetic overflow error converting expression to data type int error

For this query:

DECLARE @x  int     
IF EXISTS ( SELECT * FROM Y)     
  BEGIN          
    SET @x = (SELECT max(Id )  from Y)+1    
  END    
ELSE 
  BEGIN         
    SET @x = 1   
  END

I tried to cast Id to Big int and I also tried by changing x as Big int, but still getting same error.

@aks Did you try using the IDENTITY(1,1) for auto increment of ID column? — Techie
– Techie, Commented Sep 14, 2016 at 9:07
Is there possibility the max(Id) is the maximum value for the bigint type? — owczarek
– owczarek, Commented Sep 14, 2016 at 9:17

Hardik Boghara · Accepted Answer · 2016-09-14 09:38:10Z

1

I have tried your code nothing is wrong with it, please refer this LINK it may help you.

answered Sep 14, 2016 at 9:38

Hardik Boghara

1527 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 10:34:09Z

0

Check the ranges of values that can be stored within the types:

https://msdn.microsoft.com/en-us/library/ms187746(v=SQL.90).aspx

https://msdn.microsoft.com/en-us/library/ms187745.aspx

(and also check this: SQL Server BIGINT or DECIMAL(18,0) for primary key)

The ID column of the decimal type may cause problem in your case.

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Sep 14, 2016 at 10:27

owczarek

3472 silver badges10 bronze badges

Collectives™ on Stack Overflow

Arithmetic overflow error

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related