日期:2014-05-19  浏览次数:20622 次

无法绑定由多部分组成的标识符?
203.175.145.179是个链接服务器,在存储过程中下面这个语句保存时提示错误

DELETE   FROM   [203.175.145.179].gmexchange.dbo.APPLY_CONSUME_ALL_CP
WHERE   EXISTS   (SELECT   *   FROM   [203.175.145.179].gmexchange.dbo.MID_APPLY_CONSUME_ALL_CP
WHERE   OWNER_CODE   =   @OWNER_CODE   AND   [203.175.145.179].gmexchange.dbo.APPLY_CONSUME_ALL_CP.G_SER   =   G_SER)

提示:无法绑定由多部分组成的标识符 "[203.175.145.179].gmexchange.dbo.APPLY_CONSUME_ALL_CP.G_SER "

什么原因?怎么解决?

------解决方案--------------------
--try

DELETE T
from [203.175.145.179].gmexchange.dbo.APPLY_CONSUME_ALL_CP as T
WHERE EXISTS (SELECT * FROM [203.175.145.179].gmexchange.dbo.MID_APPLY_CONSUME_ALL_CP
WHERE OWNER_CODE = @OWNER_CODE AND T.G_SER = G_SER)