August 10, 2003 at 1:13 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.
Edited by - lital on 08/10/2003 02:06:34 AM
August 13, 2003 at 8:00 am
This was removed by the editor as SPAM
August 13, 2003 at 10:51 am
This sounds related to something that happened when we upgraded, where comarisons of numeric and varchar data do not always succeed -- probably because, instead of converting the numeric value to varchar, the transformation is reversed, and varchar values are converted to numeric values for comparison.
This can be a problem with queries and lookups. For example, if you have a varchar data field XX with mixed data, e.g.:
1
2
3
1A
2A
3A
And you try the query:
SELECT * From MyTable WHERE XX = 1
You will get an error message indicating a problem casting 1A as an int.
Can you show the query returning the issue? Also, the basic data structure of the table.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply