O'Reilly logo

Programming Microsoft® SQL Server™ 2008 by Leonard Lobel, Andrew Brust, and Stephen Forte

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

We covered a lot of ground in this chapter. SQL Server 2005 and 2008 introduce many great enhancements to the T-SQL engine. You can see that Microsoft has continued its investment in T-SQL and that it offers many powerful new ways to query complex data using T-SQL, including PIVOT, UNPIVOT, APPLY, ranking functions, TOP enhancements, GROUPING SETS, and recursive operations through common table expressions (CTEs). You’ve learned how to use table-valued parameters (TVPs) to pass sets of rows across client, server, stored procedures, and user-defined functions (UDFs). New date and time data types have also been added for your programming use, and new DML possibilities are enabled with MERGE and INSERT OVER DML.

T-SQL is still the main way ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required