SQL Server 2005's EXCEPT & INTERSECT Union-like Operators

SELECT name FROM master..sysobjects where name = 'all_columns' UNION SELECT name FROM master..sysobjects where name = 'routes'; Results:name ----------- all_columns routes SELECT name FROM master..sysobjects where name = 'all_columns' EXCEPT SELECT name FROM master..sysobjects where name = 'routes'; Results:name ----------- all_columns SELECT name FROM master..sysobjects where name = 'all_columns' INTERSECT SELECT name FROM master..sysobjects where name = 'routes'; Results:name ----------- SELECT name FROM master..sysobjects where name = 'all_columns' INTERSECT SELECT name FROM master..sysobjects where name = 'all_columns'; Results:name ----------- all_columns