What are the new features in SQL Server 2005?
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
Explain some stored procedure creating best practices or guidelines?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Explain isolation levels that sql server supports?
List the different normalization forms?
How to access the deleted record of an event?
Explain microsoft sql server functions?
Why should you use or avoid select * statements?
Give me any three differences between Truncate and Delete.
What is normalization and denormalization in sql server?
How can you insert values in multiple rows using one Insert statement?
What are the different types of upgrades that can be performed in sql server?
How do I create a stored procedure in dbml?
what are the types of indexes? : Sql server database administration
Write an SQL query to obtain the 2nd highest salary.
Please differentiate between a local and a global temporary table?