StoredProcedures are set of SQL statements, wriotten to perform
operations. It is a precompiled, hence faster retreival of data and more than one operation can be performed at a given time.
stored procedure are pre compiled subroutine. It is fast in execution because of pre-compilation.