Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between sql 2000 and 2005?
- 2 Answers
- 5612 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / khv11in
In sql server2000 Extended Stored procedures , and it
modified it into CLR Stored procedures
1.sql server 2005 include interprise manger and query
analyser together in same window we can open many window
tabs in same place but in 2000 it is in different.
2. sql server 2005 support more new datatype like xml
3. we can make more database 2(paw(20))-1 in 2005 in compare
to 2000 where not possible so much database
4. in storeprocedure we can write try catch statemenet in
2005 not in 2000
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
They mostly asked difference between versions of technologies
What is the extension of master page in asp.net?
How can you pass multiple complex types in Web API?
How many types of Cookies are available in ASP.NET?
From which base class all web forms are inherited?
What is application and session in asp.net?
How long the items in ViewState exists?
Explain the difference between authentication and authorization.
How can I configure asp.net applications that are running on a remote machine?
What are the benefits of view state?
Am not able to move the controls on the form freely in asp.net 3.5 even though I selected the position as relative or absolute for those controls. What should I do to overcome this?
Why we use dbms for projects? Why don’t we save any application data in separate files instead of dbms?
Define a web service in .net?
How do I create a web form?
How we can force all the validation controls to run?
