A stored procedure is a SQL code that you can save so you can reuse the code over and over again.
Create procedure [procedure name]
@variable datatype
As
Select * from [table] where [column] = @variable
Return