Advantages of using stored procedure in database

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.

1. They allow modular programming.
2. They allow faster execution.
3. They can reduce network traffic.
4. They can be used as a security mechanism. 

Have a nice day... 'N happy Coding :)