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
What is the difference between getdate and sysdatetime?
What are the new features in sql server 2016?
what is denormalization? : Sql server database administration
How to drop an existing user defined function in ms sql server?
What are different types of views?
What Are the Main Features of SQL Azure?
What are system databases in ms sql server?
What are different types of constraints?
What is tempdb database? : SQL Server Architecture
What are the types of resultset?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What are the rendering extensions of ssrs?
Explain how to send email from sql database?
Explain about unique identifier data type in sql server?
Can you roll back the ddl statement in a trigger?