EXCEPT and INTERSECT Comparing Tables

SELECT * FROM tableA

EXCEPT

SELECT * FROM tableB

--EXCEPT returns any distinct values from the left query that are not also found on the right query.

SELECT * FROM tableA

INTERSECT

SELECT * FROM tableB

--INTERSECT returns any distinct values that are returned by both the query on the left and right sides of the INTERSECT operand.

https://msdn.microsoft.com/en-us/library/ms188055.aspx