当前位置: 代码迷 >> Sql Server >> 无法绑定由多部分组成的标识符?该怎么解决
  详细解决方案

无法绑定由多部分组成的标识符?该怎么解决

热度:58   发布时间:2016-04-27 21:27:31.0
无法绑定由多部分组成的标识符?
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)
  相关解决方案