SQL Server :带EXCEPT的变量

-- 创建两个表
CREATE TABLE Table1 (
    ID INT,
    Name VARCHAR(50)
);

CREATE TABLE Table2 (
    ID INT,
    Name VARCHAR(50)
);

-- 向表中插入数据
INSERT INTO Table1 (ID, Name) VALUES (1, 'John');
INSERT INTO Table1 (ID, Name) VALUES (2, 'Jane');
INSERT INTO Table1 (ID, Name) VALUES (3, 'Mike');

INSERT INTO Table2 (ID, Name) VALUES (1, 'John');
INSERT INTO Table2 (ID, Name) VALUES (2, 'Jane');
INSERT INTO Table2 (ID, Name) VALUES (4, 'Tom');

-- 使用EXCEPT运算符比较两个表的数据
DECLARE @DifferentRows TABLE (
    ID INT,
    Name VARCHAR(50)
);

INSERT INTO @DifferentRows
SELECT ID, Name FROM Table1
EXCEPT
SELECT ID, Name FROM Table2;

-- 输出差异的行
SELECT * FROM @DifferentRows;