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 / yudistara

reducing network traffic..
user friendlyness..
no need to write queries every time..
sp help to improve perfrmance

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible for a stored procedure to call itself or recursive stored procedure?

946


Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1055


How can you ensure that the database and sql server based application perform well?

1072


What are the differences between stored procedure and view in sql server?

1244


What are the types of joins in sql?

1117


What are the different types of data sources in ssrs?

196


What are examples of triggers?

1086


What happens if null values are involved in arithmetic operations?

1008


What is fill factor and pad index?

1007


Explain filtered indexes benefits?

996


What is extent? Types of extents?

1184


What is the command to change the recovery model?

1043


What is the difference between grant and with grant while giving permissions to the user?

955


What is exclusive locks?

955


What is the difference between a local and a global temporary table?

1110