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).