Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     




Error "String or binary data would be truncated" in Sql 2005

This error message appears when you try to insert a string with more characters than the given column length.

The statement cannot be executed this way. You must either shorten the string to be inserted to widen the column.

1. Click on table and open its definition Where you can increase the
length of column.


Open definition of table image




Change length of the column



2. Now you can insert the elements in the table.

Share this article   |    Print    |    Article read by 1737 times
Author:
Rohit kakria
I am software developer, moderator of xpode.com
Related Articles:
Related Interview Questions: No related interview question