Wednesday, September 1, 2010

New features of SQL Server 2005/2008

2005

  • 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

No comments:

Post a Comment