Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How you can access the values from the Repeater control in ASP.NET?

1070


What is a global postback url?

952


Define satellite assemblies.

1053


Give an example of cookie abuse.

1074


How many types of sessions are there in asp net?

1002


What is asp net application object?

1016


What is the good practice to implement validations in aspx page?

1110


Define dll hell?

1078


Explain the use of fragment caching.

1100


Is it possible to create web application with both webforms and mvc?

988


Why asp.net is used?

1017


What role “#&&” plays in a querysting?

1018


What is ViewState? What does the "EnableViewState" property do? Why would I want it on or off?

1125


What are asp.net web forms?

1015


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?

2233