SQL Server: string or binary data would be truncated

Meta

文章分类 Tech

标签 SQLServer

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

string or binary data would be truncated 

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

转换一下插入的列即可

 cast (xxx as nvarchar(500))