Advantage Store Procedure:

   

             (1)Stored Procedure reduce network traffic. 

          (2) Function based access to tables

          (3) Faster Execution

          (4) Stored procedures provide better security to your data

         (5) Stored procedure allows modular programming.:-You can create the procedure once, store it in the database, and call it any number of times in your program.