New T-SQL Features


SQL Server 2005 introduced several new built-in T-SQL functions, operators, and clauses, including the INTERSECT and 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.


File System List Price Update Statement Daylight Saving Time Time Offset 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Michael Coles 2008

Personalised recommendations