SQL Stored Procedures
Reusable SQL code.
SQL Stored Procedures
A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.
Syntax
CREATE PROCEDURE procedure_name
AS
sql_statement
GO;
Execute Syntax
EXEC procedure_name;