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
What is single-user mode?
Write query to return all rows sql?
Explain primary key in sql server?
What are trace files?
What do you understand by physical_only option in dbcc checkdb?
How to get the number of affected rows?
What is the meaning of sql server?
How to execute a stored procedure in ms sql server?
What are trace flags and mention a few common trace flags used with sql server?
Difference between report and query parameter.
What is the use of “join” in sql server?
How to delete database objects with "drop" statements in ms sql server?
What are the different types of columns types constraints in the sql server?
What is coalesce in sql server?
How is table type constraint applied to a table?