what are the new features of sql server 2005?
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 is difference between views and tables?
How to transfer an existing table from one schema to another schema in ms sql server?
How do you use a subquery to find records that exist in one table and do not exist in another?
what is the system function to get the current user's user id? : Sql server database administration
What is named query? : sql server analysis services, ssas
Why use “in” clause in sql server?
Explain the stored procedure?
How to select all columns of all rows from a table with a select statement in ms sql server?
How many levels of sp nesting are possible?
What is Extended user-defined?
What is the default sql server instance name?
Write query to return all rows sql?
What is a select query statement in ms sql server?
Where can you find the error log information? : sql server database administration
How to sort the query output with order by clauses in ms sql server?