Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What are the advantages of using Stored Procedures?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


hemant kumar
What are the advantages of using Stored Procedures?
1 Answer(s)      4 years ago
Posted in : SQL


What are the advantages of using Stored Procedures?


Advertisement
View Answers

November 19, 2010 at 6:32 PM


Hi,

Here is the answer,

There are many different advantages of using Stored Procedures which is following here :

  • Reduced network usage between clients and servers
  • Enhanced hardware and software capabilities
  • Improved security
  • Centralized security, administration, and maintenance for common routines
  • Stored procedures manage, control and validate data.
  • Large queries can be avoided.
  • Reduces network traffic since they need not be recompiled.
  • Even though the stored procedure itself may be a complex piece of code, we need not write it over and over again. Hence stored procedures increases reusability of code
  • Permissions can be granted for stored procedures. Hence, increases security.

Thanks,



Related Tutorials/Questions & Answers:
Advertisements
Advertisements
 

 

 

DMCA.com