Creating Stored Procedures

A stored procedure is a named, saved batch of SQL that takes parameters. Create one with CREATE OR ALTER PROCEDURE, give parameters defaults, and run it with EXEC.

Updated

Cheat sheet: Creating Stored Procedures
Category
SQL
Level
Journeyman
Tags
BEGIN...END, EXEC, sql, Stored Procedure, t-sql