错误描述:SQL Server插入数据遇到错误string or binary data would be truncated

string or binary data would be truncated 

主要是因为对应列的字段长度不同

转换一下插入的列即可

 cast (xxx as nvarchar(500))