what are the new features of sql server 2005?
- 8 Answers
- 11418 Views
- HP, Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / skumar
There are many features introduced.
1. XML data type
2. Synonym
3. Instead of Trigger on indexed views
4. CROSS APPLY
5. INTERSECT and EXCEPT statements
6. CTE (Common Table Expressions)
7. PIVOT and UNPIVOT
8. TRY...CATCH and RAISERROR
9. .NET CLR integration
10. Custom data types
11. New data types like NTEXT,NVARCHAR,NCHAR
12.64 bit platform
13.DDL Triggers
14. New functions like RANK(),DENSE_RANK() and ROW_NUMBER
15. MAX Keyword
16. Table variable
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain system scalar functions?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are click through reports?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
List the different normalization forms?
Tell me about the approaches which you used to counter the DI problems.
What are the system database in sql server 2008?
What is sql server programming?
What is table constraint?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
How many triggers you can have on a table?
List the types of recovery model available in sql server?
Why we need sql server?
What is cursors?
What is named calculation? : sql server analysis services, ssas
