Use SQL Server 2008’s new and enhanced T-SQL programming features to create next generation database applications that support the most demanding end-user requirements.
New Table-Value Parameters Pass large amounts of data efficiently to functions and procedures using new Table-Value Parameters.

T-SQL Enhancements Perform multiple operations efficiently with the new MERGE command. Benefit from fully compatibility with Windows Server collation support, plus experience other programming improvements including the ability to:
- Insert multiple rows using a single INSERT statement
- Operate on values using rich assignment operators
- Initialize variables during declaration
SQLCLR Enhancements Create powerful User Defined Types and User Defined Aggregates that are greater than 8KB in size. Create User Defined Aggregates that allow multiple input arguments.

Download pdf Programming SQL Server