Monday, August 1, 2011

String or binary data would be truncated. Alter table SQL

Msg 8152, Level 16, State 4, Line 1
String or binary data would be truncated.
The statement has been terminated.

 

ALTER TABLE #Budtemp 
ALTER COLUMN gbobj VARCHAR(10) NOT NULL

No comments: