Difference Between Sql Server 2000 & Sql Server 2005 Features Or New

1.	Difference Between Sql Server 2000 & Sql Server 2005 Features Or New Features Of 2005 Vs 2000?
Answer» Ranking functions (ROW_NUMBER, RANK, DENSE_RANK, NTILE) Exception handling (TRY-CATCH block) CTE (Common Table EXPRESSIONS) PIVOT, UNPOVIT CUBE, ROLLUP & GROUPING SET SYNONYMS.

Difference Between Sql Server 2000 & Sql Server 2005 Features Or New Features Of 2005 Vs 2000?

Answer»