SQLServerCentral.com Articles tagged EXCEPT

Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

Thu, 29 Mar 2012 06:00:00 UT

A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.

Intersect, Except, Union, All and Any

Fri, 23 Dec 2011 07:00:00 UT

Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.

The EXCEPT and INTERSECT Operators in SQL Server

Thu, 10 Mar 2011 07:00:00 UT

The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a single result set. Rob Sheldon explains all, with plenty of examples.

Intersect, Except, Union, All and Any

Fri, 23 Dec 2011 07:00:00 UT

Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.

Caution with EXCEPT

Mon, 18 Jan 2010 07:00:00 UT

The EXCEPT operator, introduced in SQL Server 2005, can be handy in some situations where you are comparing data between two tables. New author Stephen Tirone brings us a potential issue to be aware of with this operator.

Intersect, Except, Union, All and Any

Fri, 23 Dec 2011 07:00:00 UT

Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.