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.

Answers were Sorted based on User's Feedback



What are the advantages of using stored procedures? Please don't simply say compilation time ..

Answer / paras

If your database resides on one server and you are accessing
it from different place then using Stored Procedure reduces
network traffic because you are just passing its name and
few parameters (if any)across the network instead of long query.

Is This Answer Correct ?    6 Yes 0 No

What are the advantages of using stored procedures? Please don't simply say compilation time ..

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

What are the advantages of using stored procedures? Please don't simply say compilation time ..

Answer / pradip jain

Become secure program from sql Injection.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,


Security Question- SQL DBA exparts, need your help...

3 Answers  


What are “phantom rows”?

0 Answers  


Why use identity in sql server?

0 Answers  


Explain forward - only cursors?

0 Answers  


What is deadlock and how to avoid the deadlocks.

3 Answers   TCS, Wipro,


Why are you getting errors when creating a new odbc dsn?

0 Answers  


List all types of constraints in sql server?

0 Answers  


What are the different types of sub-queries?

0 Answers  


What is nonclustered index with included columns ?

0 Answers  


What are examples of triggers?

0 Answers  


What is a deadlock and what is a live lock?

0 Answers  


Categories