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"什么原因?怎么解决?
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"什么原因?怎么解决?
如:
select * from openquery('链接服务器','select * from 表名')
这一部分是没有问题的问题出在where子句里的"[203.175.145.179].gmexchange.dbo.APPLY_CONSUME_ALL_CP.G_SER"
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)
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)