What is Store Procedure

A stored procedure is a set of structured query language statements that you assign a name and store it in to the database in a compiled form so that it can share between no of programs.

Some advantage of Store Procedure.

they allow faster execution

they can reduce network traffic