Microsoft SQL Server Error: SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated
Microsoft SQL Server Error: SQL SERVER – Msg 8152, Level 16, State 14 – String or Binary Data Would be Truncated
Details of Error:
String or binary data would be truncated. The statement has been terminated.
This error message below occurs when part data is been truncated while loading a table.
Actual error message:
Msg 8152, Level 16, State 14, Line 8
String or binary data would be truncated.
The statement has been terminated.
Resolution:
Either Shortened the data which is being truncated or increase length of the column on the Table or use below statements at the top and bottom of sql insert statement which is suppress the error
SET ANSI_WARNINGS OFF;
… Read the rest
-- Insert