errors and solving

 String or binary truncated - this occurs when one tries to input value more than it can hold for example varchar(50) can not hold 70 length data 

solution 

set ansi_warnings off