United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2008 R2

Product Documentation

SQL Server 2008 R2 Books Online

Database Engine

Technical Reference

Transact-SQL Reference

Operators (Transact-SQL)

Set Operators (Transact-SQL)

EXCEPT and INTERSECT (Transact-SQL)

UNION (Transact-SQL)

Minimize

1 out of 1 rated this helpful - Rate this topic

Set Operators (Transact-SQL)

SQL Server 2008 R2

SQL Server 2012

SQL Server provides the following set operators. Set operators combine results from two or more queries into a single result set.

Section Heading

EXCEPT and INTERSECT

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.