Okay, I'm stumped...
Date: 09/23/05
(SQL Server) Keywords: no keywords
the error message:
"The conversion of the verchar value 'xxxxxxxxxxxx' overflowed an INT1 column. Use a large intereger column."
The column is char(10). (The value is, actually, numeric; I x'ed it because it's a phone number.)
I've checked, double-checked, and triple-checked that (a) the INSERT INTO statement is putting the value in the right place; (b) the table does have the column listed as char(10); (c) the variable names are consistent across the board in putting the INSERT INTO statement together.
Anything else I should be looking at?
Source: http://www.livejournal.com/community/sqlserver/35281.html