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.

o They allow modular programming.
o They allow faster execution.
o They can reduce network traffic.
o They can be used as a security mechanism