Advantages of using stored procedures

The use of stored programs can lead to a more secure database.

Stored programs offer a mechanism to abstract data access routines, which can improve the maintainability of your code as underlying data structures evolve.

Stored programs can reduce network traffic, because the program can work on the data from within the server, rather than having to transfer the data across the network.

Stored programs can be used to implement common routines accessible from multiple applicationspossibly using otherwise incompatible frameworksexecuted either within or from outside the database server.

Database-centric logic can be isolated in stored programs and implemented by programmers with more specialized, database experience.

The use of stored programs can, under some circumstances, improve the portability of your application.

Tags: stored procedures