22,207
社区成员
发帖
与我相关
我的任务
分享
DELETE FROM [RemotServer].[DBName].dbo.Table1
WHERE Stdwno IN
(
SELECT EMP_NO
FROM #TEMP1
)
SELECT * FROM [RemotServer].[DBName].dbo.Table1
WHERE Stdwno IN
(
SELECT EMP_NO
FROM #TEMP1
)
DELETE FROM [RemotServer].[DBName].dbo.Table2
WHERE Stdwno IN
(
SELECT EMP_NO
FROM #TEMP1
)
DELETE [RemotServer].[DBName].dbo.Table1
WHERE Stdwno IN
(
SELECT EMP_NO
FROM #TEMP1
)
去掉from 試試.