What are the new features in SQL Server 2005?
- 3 Answers
- 6008 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
What is hot add cpu in sql server 2008?
What is difference statement and preparedstatement?
Write a code to select distinct records without using the DISTINCT keyword.
Differentiate between SQL and ORACLE joins and write their syntax.
What are the steps you must follow to hide sql server instances?
How to get a list of columns using the "sys.columns" view in ms sql server?
How to execute multiple stored procedures at one time in sql server?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What is a mutating table error and how can you get around it?
What is instead of trigger sql server?
How to convert a unicode strings to non-unicode strings?
What are pessimistic lock and optimistic lock?
What is the exact numeric data type in sql?
How do I find my localdb version?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
