Advantages of Stored procedure

• A stored procedure is precompiled executable object that cone or more SQL statements. Hence you can replace your complex SQL statements with a single store procedure.
  
• You expose your database schema (i.e., design) in the code which may be changed. Hence most of the time programmers used store procedures instead of plain SQL statements.
  
• Stored procedures are pre compiled objects they execute faster at the DB server. Most of time a store procedure contain more than one command. In this case, the time to pass individual commands to DB server from the program is saved. The DB is issued just one command (i.e., to execute store procedure) and the DB server executes all the commands and returns the result in the end. Hence the overall interaction time with DB server reduces in a great deal. This can result in a huge optimization in case where the DB server is accessed via slow network.