What are the advantages of using Stored Procedures?

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,









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?
creating and executing stored procedure using hibernate
the Advantages of Struts
Advantages of JSF
How to browse excel file and stored the contents into the database using jsp/servlet?
Insert Data in Table Using Stored Procedure
Advantages of ORM
advantages of Servlets
Stored Data in XML File using Servlet
stored procedure
stored procedures
stored procedures
what is the mysql in the database using php
what is the mysql in the database using php
What are the benefits of using Frameworks in PHP
passing xml created using DocumentBuilderFactory as input to oracle stored procedure using java JDBC
how to store image in folder and stored image path in mysql database using JSP
callable statement,stored procedure for insert data and also for update data into oracle database using jsp
Stored procedures
What are the ways to access Hibernate using Spring
What is TensorFlow and why big companies are using?
Advantages of XML
What is License Terms for using your code
What is the main advantage of using the hibernate than using the SQL
java client server program for playing video file(stored in folder in the same workspace) using swings
java client server program for playing video file(stored in folder in the same workspace) using swings
java client server program for playing video file(stored in folder in the same workspace) using swings
java client server program for playing video file(stored in folder in the same workspace) using swings
Hibernate Advantages
VoIP Advantages
advantages of get method?
What is an Applet
Advantages of Cloud Computing
How to passed the ID's in MAP how to stored whaterver select the name that only ID should store in db using SWING/AWT?
stored procedure
Global Positioning System Advantages
Stored Procedure and Trigger
What's the proper way to test a class with private methods using JUnit?
how to set values in object using java and what are the ways?
What are the Advantages of E-Commerce?
update date from stored procedure
image stored in mysql
Retriving data stored in database

Ads