sql - SQL - 从 SELECT 查询中删除结果

Question

我有一个链接服务器的 SELECT 语句，如下所示；

SELECT [TrackingId]
FROM  [Server1\DB].[sctracking].[dbo].[scTracking] AS A
WHERE EXISTS (SELECT * FROM [Server2\DB].[sctracking].[dbo]. [scTracking] AS B
WHERE A.Reserved = B.Reserved )

这给了我正在寻找的输出，但我真正想做的是删除结果。

谁能建议我如何将删除语句包装到其中？

标签： sqlsql-server

Answer 1

DELETE A FROM [Server1\DB].[sctracking].[dbo].[scTracking] A
WHERE EXISTS (SELECT *
              FROM [Server2\DB].[sctracking].[dbo]. [scTracking] AS B
WHERE A.Reserved = B.Reserved)