What is a Stored Procedure?
A Stored Procedure is simply a piece of saved code that can be reused.
If you have a SQL query that you write and use frequently, it is easier to save it as a stored procedure and call it later to execute it.
You can also pass parameters to a stored procedure; the procedure will act based on the parameter value(s).