Comparing Multiple SQL Server Datasets with the INTERSECT and EXCEPT

With SQL Server 2005, Microsoft introduced the INTERSECT and EXCEPT operators to further extend what you could already do with the UNION and UNION ALL operators...