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

What are the new features in SQL Server 2005?

Question Posted / manub22

3 Answers
6943 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 not null constraint?

1130

What is a trace frag? Where do we use it?

1101

Describe different Processing Modes offered by SSRS?

249

How to use transact-sql statements to access the database engine?

1069

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1148

How you can find out if an index is useful to the optimizer?

941

What is named query? : sql server analysis services, ssas

968

How you can move data or databases between servers and databases in sql server?

1054

What is dirty read?

1084

What stored by the msdb?

1003

Can the query output be sorted by multiple columns in ms sql server?

983

Which sql server is best?

999

Explain for xml explicit mode?

979

How to download and install microsoft sql server management studio express?

1040

How can you manage sql azure security?

103