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

What are the new features in SQL Server 2005?

Question Posted / manub22

3 Answers
6722 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 guidelines should be followed to help minimize deadlocks?

868

Can we use where clause with group by?

854

what is the information that can be stored inside a bit column? : Sql server database administration

901

How to get all stored procedures in sql server?

936

What's the information that can be stored inside a bit column?

936

What is bit data type? What's the information that can be stored inside a bit column?

873

What is difference between standardization and normalization?

1016

What is inline table-value user-defined function?

1010

Do you know spatial data types - geometry and geography in sql server 2008?

968

What is the sql profiler?

898

How to concatenate two binary strings together?

1047

What is policy based management (pbm)? : sql server database administration

927

Is the order of columns in the set clause important in ms sql server?

925

What are the security related catalog views? : sql server security

912

Is ssrs support other database except ms sql server?

127