Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 53171 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
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What are the types of indexing?
how we use window authentication connection with sql server.?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Explain transaction server consistency?
What is the purpose of forms?
What is the process of indexing?
Difference between connected and disconnected database in .net with sql server?
Define self join in sql server joins?
What are the basic features of a trigger in ms sql server?
Do you know what is difference between index seek vs. Index scan?
What is in place upgrade in sql server?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How to list all user defined functions in the current database?
Explain Reporting Life Cycle?
