What two commands were released in SQL Server 2005 related to comparing data sets from two or more separate SELECT statements?

Technology CommunityCategory: T-SQLWhat two commands were released in SQL Server 2005 related to comparing data sets from two or more separate SELECT statements?
VietMX Staff asked 3 years ago
  • INTERSECT – Final result set where values in both of the tables match
  • EXCEPT – Final result set where data exists in the first dataset and not in the second dataset