Search This Blog

Tuesday, November 8, 2011

SQL Error : String or Binary data would be truncated




String or Binary data would be truncated

This is well known error. This could occur when your are trying to insert some values into
a table through stored procedure or query etc.

Solution: This error occurs when one of the column SIZE in the table is very small compared
to the value being inserted. So closely check all the column sizes, change it accordingly
and then try to insert the values.

No comments:

Post a Comment