:::: MENU ::::

String or binary data would be truncated.

  • Apr 04 / 2009
  • 0
dbDigger

String or binary data would be truncated.

The error message
Msg 8152, Level 16, State 14, Line 5
String or binary data would be truncated.
is a run time error message and may occur while working with strings/characters. It appears when you try to insert a string with more characters than the column can accommodate. Obviously to resolve the error either you have to shorten the string or amend the column to increase the length of data type.

Consult us to explore the Databases. Contact us