Hi

I am running an INSERT form one tables into another. I am getting below error;

Msg 8152, Level 16, State 10, Line 10
String or binary data would be truncated.

As I have a whole bunch of columns how do I figure which column is involved in error?

Thanks

Regards

Take a look at this blog post

How to find what column caused the String or binary data would be truncated message 

Hi Yahya,

The length of the data in source table is biggest than destination table.

You can compare the columns by the CHARACTER_MAXIMUM_LENGTH in both tables (Source Column and Destination Column) by the following command:

SELECT COLUMN_NAME,* 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'YourTableName' AND TABLE_SCHEMA='YourSchemaName'

Best Regards

Your Destination column size is less lesser and Data insertion length is high .Increase column lengh in destinat

Simple matter,

Source table's column length is higher than destination .