advantages of stored procedures sql

1A Stored Procedure can be used as a 
2modular programming which means create once, 
3store and call for several times whenever
4it is required. This supports faster execution.
5It also reduces network traffic and
6provides better security to the data.

1Disadvantage:
2The only disadvantage of Stored Procedure 
3is that it can be executed only in the
4database and utilizes more memory in 
5the database server.