1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are the new features in SQL Server 2005?

Question Posted / manub22

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

How to resolve the orphan use problem? : sql server security

532

What is sharding?

88

Explain what are the basic functions for master, msdb, model, tempdb databases?

533

Can you explain what is indexed view? How to create it?

534

What is a schema in ms sql server 2005?

567




Explain different forms of normalization?

534

What is efficiency data?

527

Define model database?

577

What are the 2 types of classifications of constraints in the sql server?

592

What is mean by dml?

543

What is clr ddl trigger?

552

What is the security principal at the server level that represents your session?

563

How to find out what is the default collation in a database?

634

What is field with example?

519

What will be query used to get the list of triggers in a database?

552