24 Jun 2022

Stored Procedure

Stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.

Creation

CREATE PROCEDURE procedure_name
AS
sql_statement
GO;

Execution

EXEC procedure_name;