what are the new features of sql server 2005?
- 8 Answers
- 11847 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
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is normalization? Explain its different types?
What is temporary stored procedure?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Explain how dts is used to extract, transform and consolidate data?
What is raid, and how it can influence database performance?
What is a group function explain with an example?
What is the importance of concurrency control?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Mention the different authentication modes in sql server.
Which tcp/ip port does the sql server run on? How can it be changed?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
What are the different normalization forms?
How to create a new login name in ms sql server?
