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

What are the new features in SQL Server 2005?

Question Posted / manub22

3 Answers
6930 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

What is single-user mode?

927

Write query to return all rows sql?

1051

Explain primary key in sql server?

1014

What are trace files?

950

What do you understand by physical_only option in dbcc checkdb?

977

How to get the number of affected rows?

998

What is the meaning of sql server?

986

How to execute a stored procedure in ms sql server?

1167

What are trace flags and mention a few common trace flags used with sql server?

1083

Difference between report and query parameter.

1093

What is the use of “join” in sql server?

1087

How to delete database objects with "drop" statements in ms sql server?

1084

What are the different types of columns types constraints in the sql server?

1080

What is coalesce in sql server?

1050

How is table type constraint applied to a table?

977