Using SQL Server 2008’s EXCEPT and INTERSECT Statements

(Eric Johnson) SQL Server 2008 shipped with several enhancements to the T-SQL language. In a recent blog, we looked at the new MERGE syntax; today we are going to look at the new EXCEPT and INTERSECT syntax. Both of these operators allow you to compare results of two queries. Using EXCEPT, you can f

Read More - Register for Free Membership