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

![Cheat sheet: Creating Stored Procedures](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/4c38527c2f55446fbf22b8713860e991.webp)

- Category: SQL
- Level: Journeyman
- Tags: BEGIN...END, EXEC, sql, Stored Procedure, t-sql
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/stored-procedures-in-t-sql-creating-stored-procedures-cheat-sheet