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 advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages.

Answer Posted / santosh kumar sharma

You can encapsulate your business logic in SP. Easy to
maintain as any changes in the business logic, you'll just
have to alter the SP and not your application.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a live lock? : Sql server database administration

886


what type of index will get created after executing the above statement? : Sql server database administration

917


How do I find the transaction log size in sql server?

914


What is the distinction amongst delete and truncate?

1000


What does the not null constraint do?

995


As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1060


How to create a view using data from another view?

901


What are trace flags?

958


What is difference between count (*) and count column?

838


Can a trigger be created on a view?

892


Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1094


1 01 101 01010

2001


What is openrowset sql server?

1056


What is the difference between DATETIME2 and DATETIME?

1013


How will you know when statistics on a table are obsolete?

1029