Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 53188 Views
- Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain, I also Faced
- E-Mail Answers
Answer Posted / anish nama
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 ? | 33 Yes | 7 No |
Post New Answer View All Answers
Can you roll back the ddl statement in a trigger?
What is etl - extraction, transformation, and loading?
what is database replication? : Sql server database administration
what are the different types of SSRS reports?
Can I use sql azure as a backup with log shipping or database mirroring?
What are data files?
How many types of cursor type are there?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Explain syntax for dropping triggers?
What are the basic functions for master, msdb, model, tempdb databases?
Why is normalisation important?
Can we use pragma autonomous_transaction in trigger?
What happens if you delete a table that is used by a view?
Can we join two tables without primary key?
How to handle error or exception in sql?
