create stored procedure in sql

A stored procedure is a group of SQL statements compiled into one unit for later use and can be used many times.