What are the advantages of using Stored Procedures?

Ads
 

What are the advantages of using Stored Procedures?

What are the advantages of using Stored Procedures?

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,

Ads









Related Tutorials/Questions & Answers:
What are the advantages of using Stored Procedures?
What are the advantages and disadvantages of CSS?
Advertisements
What are Advantages and Disadvantages of AJAX
What are the advantages of Hibernate?
What is Stored Procedure?
What are the features and advantages of OBJECT ORIENTED PROGRAMMING?
what is the Advantages moqui framework vs other frameworks
What are the advantages and disadvantages of fleet management?
the Advantages of Struts
Advantages of JSF
creating and executing stored procedure using hibernate
Advantages of ORM
How to browse excel file and stored the contents into the database using jsp/servlet?
Insert Data in Table Using Stored Procedure
advantages of Servlets
stored procedures
stored procedures
stored procedure
Stored Data in XML File using Servlet
what is the mysql in the database using php
what is the mysql in the database using php
how to store image in folder and stored image path in mysql database using JSP
What are the benefits of using Frameworks in PHP
passing xml created using DocumentBuilderFactory as input to oracle stored procedure using java JDBC
Stored procedures
What are the ways to access Hibernate using Spring
What is the main advantage of using the hibernate than using the SQL
callable statement,stored procedure for insert data and also for update data into oracle database using jsp
Advantages of XML
What is TensorFlow and why big companies are using?
advantages of get method?

Ads