Friday, August 5, 2011

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

If you are getting  error like

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

this error means that the nchar() is unable to save all the elements, because the nchar() size is small.

To fix this just increase the size of nchar() to something bigger.

save it and than run your query.


No comments:

Post a Comment