- The PIVOT statement
- Common table expressions (CTEs) and recursive queries (part 1 of 2)
- CTEs and recursive queries (part 2 of 2)
- OUTPUT and OUTPUT INTO, to gain immediate access to the system INSERTED and DELETED tables
- Isolation levels (part 1 of 2)
- Isolation levels (part 2 of 2)
- New XQUERY capabilities to handle variable number of selections
- Variable TOP N APPLY and table-valued UDFs
- RANKING and PARTITIONING
- New TRY…CATCH capabilities and RAISING errors
- INTERSECT/EXCEPT
- Flexible UPDATE procedures
Thursday, December 6, 2007
13 Productivity Tips for Transact-SQL 2005
The Baker's Dozen: 13 Productivity Tips for Transact-SQL 2005
