- Exception Handling using TRY-CATCH
- CTE (Common Table Expression)
- PIVOT
- CLR
- New functions (ROW_NUMBER, RANK, DENSE_RANK )
- New operands (INTERSECT, EXCEPT)
- New clause (OUTPUT, TABLESTAMP)
- New DataType (XML)
- Data Tuning Advisor
2008
- Intellisense
- Policy Based Management
- New Operator (MERGE)
- Filtered Index
- New DataTypes (HIERARCHYID, DATE)
- Query Editor Regions
- Table Valued Parameters
- Filestream
- CDC (Change Data Capture)
No comments:
Post a Comment