How to solve the “String or binary data would be truncated.\r\nThe statement has been terminated.” error? - cSharp Coder

Latest

cSharp Coder

Sharp Future

Thursday, July 9, 2020

How to solve the “String or binary data would be truncated.\r\nThe statement has been terminated.” error?

The specified error, "String or binary data would be truncated.\r\nThe statement has been terminated." is showing when you are trying to insert a value that is higher than the specified size of the column, When we look into the given procedure we can't identify the sizes of each column, So it would better if you cross check the sizes of columns with the values that you are giving.


1 comment:

  1. very nice it save my time . thanks a lot

    ReplyDelete