zl程序教程

您现在的位置是:首页 >  后端

当前栏目

SQL Server: string or binary data would be truncated

serverSQL string be Data or Binary would
2023-06-13 09:11:18 时间

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

string or binary data would be truncated 

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

转换一下插入的列即可

 cast (xxx as nvarchar(500))