Finding Rows That Are NOT in the Other RowSet with EXCEPT

The EXCEPT operator returns all the rows in the left RowSet that are not in the right RowSet.

EXCEPT ALL

@a_except_b_all =
   SELECT * FROM @a
   EXCEPT ALL
   SELECT * FROM @b;

@a_except_b_all

@b_except_a_all =
   SELECT * FROM @b
   EXCEPT ALL
   SELECT * FROM @a;

@b_except_a_all

EXCEPT DISTINCT

@a_except_b_distinct =
   SELECT * FROM @a
   EXCEPT DISTINCT
   SELECT * FROM @b;

@a_except_b_distinct

@b_except_a_distinct =
   SELECT * FROM @b
   EXCEPT DISTINCT
   SELECT * FROM @a;

@b_except_a_distinct