SQL Server 2005 introduced several new built-in T-SQL functions, operators, and clauses, including the
EXCEPT operators and the DML statement
OUTPUT clause. SQL Server 2008 supports these prior enhancements and adds some of its own. In this chapter, I will cover the developer-centric T-SQL features that I haven't discussed in previous chapters.
SQL Server has long supported the
UNION ALL set-based operators to combine the results of multiple queries into a single result set. SQL Server 2008 also supports the
EXCEPT set-based operators, which allow you to use entire result sets to restrict the results returned by queries. The
INTERSECT operator takes two queries, one ...