SQLServerCentral.com Articles tagged UNION

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.

Whether to use UNION or OR in SQL Server Queries

Wed, 06 Jul 2011 06:00:00 UT

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

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.

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

Mon, 08 Mar 2010 07:00:00 UT

This article gives a description of the iff() and DLookup() functions in Access 2007, and a method to converting them to SQL.

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.

Using the Union Statement - SQL School Video

Tue, 24 Mar 2009 06:00:00 UT

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.