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

    string or binary data would be truncated 
    

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

    转换一下插入的列即可

     cast (xxx as nvarchar(500))