HEXAQ : A friendly question - answer site for IT professionals

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


0

I am developing my educational project using ASP.NET and SQL server.

I have inserted many records and now since mornig I am getting an error. I am trying to insert a record that throw error

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

Any solution that help me to keep mye xisting records and solve this error?

Â
asked
 


≡ Total 1 Answer

0

this happens when you try to insert longer text than the field maximum site.

Reduce the string length using sub string function in SQL or increase the column width in your table.

Â
replied


Enter your reply here
Answer Preview:
Viewed: 739 times
Asked on: 7/15/2013
Permalink
Topics in this question
  19
Search Question
Similler Questions