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 ...
Get Programming Microsoft® SQL Server™ 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
