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

Articles with tag UNION Rss

Search for any content tagged union

   Items 1 to 7 of 7   
 

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,789 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,696 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,923 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,696 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,647 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,696 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,634 reads
   Items 1 to 7 of 7