Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 51250 Views
- Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain, I also Faced
- E-Mail Answers
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 resource governor in sql server?
Why use cursor in sql server?
what is the difference between delete table and truncate table commands? : Sql server database administration
What is save transaction and save point?
What is index fragmentation in ms sql server?
Where are sql server user names and passwords stored in sql server?
What is the difference between Normalization and De-normalization?
Tell me what are the advantages of using stored procedures?
What type of locking occurs during the snapshot generation? : sql server replication
What is the use of builtinadministrators group in sql server? : sql server security
What is a ddl statement?
How to list all dsn entries on your local machine using odbc_data_source()?
What is the use of RDBMS?
In what version of sql server were synonyms released?
How can sql server instances be hidden?
