String or binary data would be truncated.
The statement has been terminated.
Is there an easy way to know for which column the problem is coming,in case of insert, and for which row value (or string)"
I have 181 Columns having varchar type with more then 18000 Rows..
Now I added 50 more columns to this table and create a new table
I am running query
insert into table2( < 181 column names> )
select <181 Column Names > from Table1
I am getting this error How can I get the Specific Column Name for which column the problem is coming