Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, EXCEPT Rss

   Items 1 to 11 of 11   
 

Using EXCEPT to Determine Row Differences

How to use the EXCEPT statement to perform row differences.  Read more...
By M. Douglas Bowan II 2014/03/25 | Source: SQLServerCentral.com | Category: except
Rating: |  Discuss |   Briefcase | 15,018 reads

EXCEPT 2

By bitbucket-25253 2014/03/03 | Category: except
Rating: (not yet rated) |  Discuss |   Briefcase | 1,851 reads

BETWEEN a hard place and a rock

By Hugo Kornelis 2013/06/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,601 reads

EXCEPT - 1

By bitbucket-25253 2013/05/20 | Category: except
Rating: (not yet rated) |  Discuss |   Briefcase | 1,970 reads

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

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.  Read more...
By Jeff Moden 2012/03/29 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,389 reads

Intersect, Except, Union, All and Any

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.  Read more...
By David Poole 2011/12/23 (first published: 2009/07/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 39,629 reads

exceptional logic

By BenWard 2011/10/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,521 reads

The EXCEPT and INTERSECT Operators in SQL Server

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.  Read more...
By Additional Articles 2011/03/10 | Source: SQLServerCentral.com | Category: t-sql
Rating:  Rate this |   Briefcase | 5,419 reads

Intersect, Except, Union, All and Any

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.  Read more...
By David Poole 2011/12/23 (first published: 2009/07/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 39,629 reads

Caution with EXCEPT

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.  Read more...
By Stephen Tirone 2010/01/18 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 13,098 reads

Intersect, Except, Union, All and Any

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.  Read more...
By David Poole 2011/12/23 (first published: 2009/07/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 39,629 reads
   Items 1 to 11 of 11   
 
Tags
intersect (2)    
union (2)    
group by (1)    
having (1)    
null (1)    
subquery (1)