August 5, 2003 at 5:20 pm
Hi all,
I transfered a text table into sql table.
sql database table only has 2 columns.
I choose char.
When I query a number I got the following error:
[ODBC SQL Server Drive][SQL Server] The convertion of the varchar value '8000566500'
overflowed an int column. Maximun integer value exceeded.
Should I change the data type to varchar?
Please help. Thanks!
Robert
August 5, 2003 at 5:37 pm
That's strange. What is its current data type? It sounds like it's already varchar, otherwise it wouldn't be trying to convert it from varchar when you query the table. Would it?
Can you post sp_help results for the table?
Cheers,
- Mark
Cheers,
- Mark
August 5, 2003 at 5:48 pm
I am sorry, when I query I forgot ''.
Now it's no problem. It's really a funny mistake. Thank you as well.
Robert
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply