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)