August 10, 2003 at 2:09 am
After upgrading from sql server 7 to 2000 i getting the error:
Server: Msg 248, Level 16, State 1, Line 1
The conversion of the varchar value '13495112479' overflowed an int column. Maximum integer value exceeded.
The statement has been terminated.
August 10, 2003 at 7:36 am
Are you sure it worked before? That is way outside the upper bound for an int, which is 2,147,483,648.
Andy
August 10, 2003 at 4:19 pm
It probably worked before because it was a varchar, not an int. Can you change the data type to bigint or back to varchar?
August 13, 2003 at 6:22 am
Thanks to all I found the problem,
in sql 2000 numeric values are not implicitly converted to characters within a string concatenation statment
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply