这个错误是什么......？ [英] what is this error....?

问题描述

更新fs set fs.C_Parent = f。[报告代码]

来自fsc f

加入Tbl_FS_Mst fs on fs.C_Code = [fscode]

加入Tstl_FS_Mst fst on fst.C_Code = fs.C_Parent

其中fst.C_Name喜欢'空缺％'





如果我执行此查询我收到错误



Msg 8152，Level 16，State 2，Line 1

String或二进制数据将被截断。

该语句已被终止。



你能告诉它可能是什么问题..

update fs set fs.C_Parent=f.[reporting code]
from fsc f
join Tbl_FS_Mst fs on fs.C_Code=[fscode]
join Tbl_FS_Mst fst on fst.C_Code=fs.C_Parent
where fst.C_Name like 'vacant%'


If i execute this query Am getting error

Msg 8152, Level 16, State 2, Line 1
String or binary data would be truncated.
The statement has been terminated.

can you tell what problem it could be..

推荐答案

在没有看到您的数据库的情况下，我可以告诉您，您正在尝试将

a值插入到超出其长度的数据库列中。



例如一列被定义为国家varchar（5）

你试图插入德国这个错误将发生

因为这个值的长度大于数据库列允许。

Without seeing your database I can tell you that you are trying to insert
a value into a database column which exceeds its length.

e.g. a column is defined as "Country varchar(5)"
and you try to insert "Germany" this error will occur
as the length of this value is greater than the database column allows.

这篇关于这个错误是什么......？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！