Xpode.com        Click here to Print this article.

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.


Contributed by:
Rohit kakria
I am software developer, moderator of xpode.com

Resourse address on xpode.com

Click here to go on website