Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
A stored procedure is a set of Structured Query Language (SQL) statements that you assign a name to and store in a database in compiled form so that you can share it between a number of programs. • They allow modular programming. • They allow faster execution. • They can reduce network traffic. • They can be used as a security mechanism.