what is the difference between sql 2000 and 2005?
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 you can access the values from the Repeater control in ASP.NET?
What is a global postback url?
Define satellite assemblies.
Give an example of cookie abuse.
How many types of sessions are there in asp net?
What is asp net application object?
What is the good practice to implement validations in aspx page?
Define dll hell?
Explain the use of fragment caching.
Is it possible to create web application with both webforms and mvc?
Why asp.net is used?
What role “#&&” plays in a querysting?
What is ViewState? What does the "EnableViewState" property do? Why would I want it on or off?
What are asp.net web forms?
1.What r collections? 2.What is .pdb file? 3.Is it possible to provide access to users in master page? 4.What is dirty n Phantom Read(SQL)? 5.What r different isolation levels(SQL)? 6.How to set authentication mode in web.config file?