what is the difference between sql 2000 and 2005?
- 2 Answers
- 4766 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
How many types of validation are there?
if i wanna deploy my asp.net project to the production server and situation is that i m still not compiled my project i have as-is on my development side now on production server we dont have a visual studio now what kind of settings i need to be to do in webconfig /machine.config file to deploy my project and in iis too....
What are Master Pages in ASP.NET? or What is a Master Page?
Explain the main function of url routing system in asp.net mvc? : asp.net mvc
What language is asp.net written in?
What are html helpers in asp.net?
Explain about Application and Session Events ?
Name some asp objects?
What is the exact purpose of http handlers?
How can we create Tree control in asp.net?
What is _dopostback in asp net?
What are the advantages of asp.net?
Which property is used to identify the Page is Post Back in ASP.NET?
Differentiate between client-side and server-side validations in web pages.
Explain what is clr?
