Monday, 11 June 2012

String or binary data would be truncated. The statement has been terminated

The error

String or binary data would be truncated. The statement has been terminated.
 
occurs when we try to insert or update data which is passed having length greater than which is specified in the database.
For Example
Column Name      Data Type
Description              varchar(50)
But we given more than 50 characters its will be truncated.


happy coding!!
 

No comments:

Post a Comment