System.Data.SqlClient.SqlException: String or binary data would be truncated

This issue occurs because the field size of temporary tables is truncated when the tables are created. Then, rows are inserted that exceed the size of the field.

Advertisements

4 thoughts on “System.Data.SqlClient.SqlException: String or binary data would be truncated

  1. Check the schema column size and match it with the parameter size in the SP call. And use varchar field for the column if at all it is not having any specific data type constraints.

  2. showing one error “string or binary data would be truncated” in one system, but the same application working in another system properly.

    Data base is “SQL2005”

    Give me solution.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s