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

Content with tag UNION Rss

   Items 1 to 11 of 11   
 

SQL Server Operations from Set Theory

SQL Server provides the UNION, EXCEPT, and INTERSECT set operations. How do they work and how can they be used in SQL Server? Can you provide any examples? Check out this tip to learn more.  Read more...
By Additional Articles 2013/11/25 | Source: MSSQLTips.com | Category: operations
Rating: (not yet rated)  Rate this |   Briefcase | 4,734 reads

Union Forcing Distinct

The use of union would seem to force a distinct in each of the select statements being unioned. The use multiple unions, with mixed union and union all clauses, seems to cause haphazard results.  Read more...
By Clyde Merrell 2013/05/14 | Source: SQLServerCentral.com | Category: union
Rating: |  Discuss |   Briefcase | 865 reads

Combining union and union all

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

exceptional logic

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

Union results

By Jason Whitish 2011/09/22 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,616 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,904 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,664 reads

Converting Access Queries with iff() and DLookup() to SQL Server

This article gives a description of the iff() and DLookup() functions in Access 2007, and a method to converting them to SQL.  Read more...
By Fred Simmons 2010/03/08 | Source: SQLServerCentral.com | Category: access
Rating: |  Discuss |   Briefcase | 7,640 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,664 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,593 reads
   Items 1 to 11 of 11   
 
Tags
t-sql (6)    
except (3)    
intersect (2)    
union all (2)    
access (1)    
distinct (1)    
dlookup (1)    
iif (1)    
operations (1)    
or (1)    
video (1)