- CTE - APPLY OPERATOR (CROSS, OUTER) - OVER CLAUSE with PARTITION BY -

What are the new features in SQL Server 2005?

Question Posted / manub22

3 Answers
7088 Views
Emphasis, I also Faced
E-Mail Answers

Answer Posted / manub22

- CTE
- APPLY OPERATOR (CROSS, OUTER)
- OVER CLAUSE with PARTITION BY
- RANKING FUNCTIONS
- PIVOT & UNPIVOT
- Synonyms

Check here all new features in SQL Server 2005: http://sqlwithmanoj.com/category/sql-server-versions/sql-server-2005-sql-server-versions/

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain log shipping and mention its advantages.

1090

What is the difference between cartesian product and cross join?

906

How we can refresh the view?

1160

Explain triggers in sql?

1003

how to trace the traffic hitting a sql server? : Sql server database administration

1956

Name 3 ways to get an accurate count of the number of records in a table?

1088

Ways to improve the performance of a SQL Azure Database?

125

Explain how many types of relationship?

1086

what are the different types of SSRS reports?

160

What are the mathematical functions supported by sql server 2005?

1127

what is an extended stored procedure? : Sql server database administration

1111

Describe triggers features and limitations?

1055

Does table partitioning improve performance?

1015

How to delete duplicate rows in sql server?

1155

role of sql sever 2005 in database rather than any other database

1992