I have the following table:
curr_id int 4 NOT NULL
curr_Name varchar 50 NOT NULL
curr_Exchange_Rate decimal 9 (18,5)
curr_Short varchar 15
and the following SQL statement, which is put together in an ASP file:
insert into Currencies (curr_name, curr_exchangeRate, curr_short) values ('<new Currency>','0.0','<new Unit>')
Executing it via the ASP page returns "String or binary data would be truncated".
But executing it with Query Analyzer inserts it correctly.