SQL 2008 Overflowed an int but the value is..integer...

Question

Hi guys, having

create table #rete (mpo int)

insert into rete (mpo) values ('2380001112857')

The conversion of the varchar value '2380001112857' overflowed an int column

Why? I'm inserting two million rows but I'm struck because this stupid issue. I don want put mpo as nvarchar because the tables I need to link later have mpo as int...

Any sugegstion. Thank you

Answer 1

And now, even if I wiped away the mpo column it continues a give me :

Arithmetic overflow error converting numeric to data type numeric.

That's belong some other data...I gonna to check it....

Answer 2

You need to change the column data type to bigint to hold the value:

create table #rete (mpo bigint)

insert into #rete (mpo) values ('2380001112857')

Select * from #rete
 

drop table #rete

Answer 3

thats because of some other large value in your insert which is greater than max range of numeric datatype

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

Answer 4

Hi,

SQL Server largest int is 2147483647, so you overflowed it.

Try declaring your mpo field as bigint instead.

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

Answer 5

Its out of range

int

-2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)

4 Bytes

http://technet.microsoft.com/en-us/library/ms187745.aspx

---

Satheesh
My Blog | How to ask questions in technical forum