Interested to Buy Any Domain ? << Click Here >> for more details...
what are the new features of sql server 2005?
- 8 Answers
- 13255 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
What are the different editions available in sql server 2000?
What is SubQuery in SQL Server 2008
what are the critical issues you have resloved in your company
What is sql server english query?
Write a program to fetch first 10 records from a file?
What is openrowset sql server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
If the job running very slow what is the action you do
What is a partition function in sql server?
What are triggers? How do you invoke a trigger on demand?
Using the customer, and order table in northwind database, please write a query to produce xml?
How to download microsoft sql server 2005 express edition?
Tell me what is the order in which the sql query is executed?
How to make conditional sum in ssrs?
What is intellisense?
