SQLServerCentral.com Articles tagged Intersect

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.

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

The EXCEPT and INTERSECT Operators in SQL Server

Thu, 10 Mar 2011 07:00:00 UT

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.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

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.

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 Intersect - SQL School Video

Tue, 17 Mar 2009 06:00:00 UT

This SQL School video will introduce you to the INTERSECT command in T-SQL. MVP Andy Warren explains how this command allows you to find matching rows in a join and a UNION.