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
Can we use where clause with group by?
What is an entity-relationship diagram (erd)?
Tell me about builtinadministrator?
How to use old values to define new values in update statements in ms sql server?
Difference between Sql server reporting services and Crystal reports?
What is wrong with sql server client libarary dll, ntwdblib.dll?
Do you know hot add cpu in sql server 2008?
What is the name of the Database which IBM mainframe uses?
Where is trigger in sql server?
How to select an exiting database using mssql_select_db()?
How will you make an attribute not process? : sql server analysis services, ssas
What are four major operators that can be used to combine conditions on a where clause?
What is the use of builtinadministrators group in sql server? : sql server security
What is ms sql server index?
How can you list all the columns in a database?