字符串或二进制数据将被截断
消息 8152，16 级，状态 14，第 60 行 字符串或二进制数据将被截断。
我正在尝试插入临时表。直到昨天，这个过程一直在测试中运行良好。我收到截断错误，修复了一个字段，然后它开始工作。今天我运行它，再次出现截断错误。我尝试将插入中的所有字段设置为 max 和 8000，但无济于事。临时表是否有某种数据限制。我对输入的所有最大长度进行了评估，它们都在表结构的限制内。
临时表相当大，但我认为这是必要的。
Msg 8152, Level 16, State 14, Line 60
String or binary data would be truncated.
I am trying to insert into a temp table. This proc has been working through testing fine until yesterday. I got the truncate error, fixed a field and it began working. Today I ran it and I get the truncate error again. I tried setting all the fields in the insert equal to max and 8000 but to no avail. Is there some sort of data limit restriction to temp tables. I ran evaluations of all the max lengths of the input and all of them are within limit of the table construction.
The Temp Table is pretty large but is in my opinion necessary.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
gbn无疑是正确的。你对长度的评估是错误的。
但是，如果您只想让截断发生并忽略它，您可以SET ANSI_WARNINGS< /a> 关闭
gbn is undoubtedly correct. You're evaluation of the lengths is off.
However if you want to just let the truncate happen and ignore it you can just SET ANSI_WARNINGS off