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 are the benefits of using stored procedures over sql
statements?

Answer Posted / vishnu

reduces network traffic
boost up the performance
eliminate webserver overhead
it takes input parameters
if we modify it, clients 'll get newer version automatically

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1069


Do you know what are acid properties of transaction?

964


Where is localdb stored?

952


How to insert new line characters into strings?

999


Detail about query optimizer?

1115


What sql server means?

972


Can we call stored procedure in view in sql server?

906


What is cached report?

148


What is a view in sql?

980


What are dml triggers and types of dml triggers?

986


how can you check the level of fragmentation on a table? : Sql server administration

991


What is meant by indexing files?

1048


What is role playing dimension with two examples? : sql server analysis services, ssas

1014


In how many ways you can invoke ssrs reports?

143


How to write a query with a right outer join in ms sql server?

921