Difference between sql server 2000 and sql server 2005?

Answer Posted / bhaskar

Sql server 2005 New features:
1.Datatype varchar(max),XML datatype
2.OUTPUT Clause
3.APPLY OPERATOR
4. PIVOT and UNPIVOT?
A Pivot Table can automatically sort, count, and total the
data stored in one table or spreadsheet and create a second
table displaying the summarized data. The PIVOT operator
turns the values of a specified column into column names,
effectively rotating a table.

5.Tools and utilities
Data types
T-SQL enhancements
Programmability enhancements
XML support
Native XML web services
SQL Management Objects
SQL Server Integration Services
SQL Server Reporting Services
SQL Server Notification Services
SQL Server Service Broker
Replication Management Objects
SQL Server Agent
SQL Server Mobile Edition
The code used in the book is available

In sql server2000 Extended Stored procedures , and it
modified it into CLR Stored procedures


Is This Answer Correct ?    72 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference RDBMS and Graph Database?

848


What are the different types of join?

859


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1851


What is difference between join and natural join?

688


How to write a query with a full outer join in ms sql server?

779


Does any body please help me what question's have asked for SSRS in the interview?

1944


What is lock escalation and what is its purpose?

770


How can a user-defined datatype be created?

765


How to perform backup for certificates in sql server? : sql server security

814


What is enhanced database mirroring in sql server 2008?

725


What is the purpose of the master database?

866


How to use subqueries with the exists operators in ms sql server?

862


Why I am getting "the microsoft .net framework 2.0 in not installed" message?

756


What is the concept of optimization?

835


What are the types of containers in ssis?

831