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

application server is slow what may be the problem

1988


How each E-R model constructs can be mapped to the relational model?

740


What are differences in between sql server 2012 and sql server 2016?

782


Does partitioning improve performance sql server?

680


Explain the usage of floor function in sql server.

716


How can you insert values in multiple rows using one Insert statement?

826


What is the importance of three tier architecture?

858


What is usually the first word in a sql query?

852


What stored by the master? : sql server database administration

789


as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

677


Write a sql query to get zero records from a table having n number of records?

950


What is difference between views and tables?

676


How self join is different from outer join?

817


Why use stored procedures in sql server?

747


How to check table values in sql server?

725