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

Content with tags T-SQL, UNION Rss

   Items 1 to 9 of 9   
 

RAND Unions

By Steve Jones 2014/09/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,721 reads

Combining union and union all

By Richard Rozema 2012/03/08 | Category: union
Rating: (not yet rated) |  Discuss |   Briefcase | 2,665 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,686 reads

exceptional logic

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

Union results

By Jason Whitish 2011/09/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,622 reads

Whether to use UNION or OR in SQL Server Queries

Recently I came across with an article on DB2 about using Union instead of OR. So I thought of carrying out a research on SQL Server on what scenarios UNION is optimal in and which scenarios OR would be best. I will analyze this with a few scenarios using samples taken from the AdventureWorks database  Read more...
By Additional Articles 2011/07/06 | Source: SQL Server Performance | Category: t-sql
Rating:  Rate this |   Briefcase | 5,917 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,686 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,686 reads

Using the Union Statement - SQL School Video

In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.  Read more...
By Andy Warren 2009/03/24 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 6,614 reads
   Items 1 to 9 of 9   
 
Tags
except (2)    
intersect (1)    
or (1)    
rand() (1)    
union all (1)    
video (1)