Manipulating Result Sets

SQL Server allows you to manipulate and control the results of queries by combining result sets and views, working with temporary result sets, producing summary reports of result sets, and sending notifications when result sets change. The following topics provide more information about these features.

In This Section

Topic Description

Combining Results Sets with UNION

Explains how to combine the results of two or more SELECT statements into a single result set.

Performing Semi-Joins with EXCEPT and INTERSECT

Explains how to compare the results of two or more SELECT statements and return distinct values.

Using Common Table Expressions

Explains how to work with table-valued expressions in a query.

Summarizing Data

Introduces the CUBE, ROLLUP, and COMPUTE operators for summarizing data.

Using Partitioned Views

Introduces the use of views that split data from a large table across one or more servers.

Using Query Notifications

Explains how to program an application to respond to changes in query results.