# Stored Procedure

A named, saved set of SQL statements with parameters.

## What is **Stored Procedure**?

A **stored procedure** is a named, saved set of SQL statements with parameters, run with `EXEC`. It keeps logic in one place and lets apps call it by name.

```sql
CREATE PROCEDURE dbo.GetRecipesByCategory
    @category NVARCHAR(50)
AS
BEGIN
    SET NOCOUNT ON;
    SELECT Title, Minutes FROM dbo.Recipes WHERE Category = @category;
END
```

Level: Journeyman · [More Database terms at this level](https://www.ask-codey.com/glossary/subjects/database/journeyman)

Updated: September 27, 2026

Source: https://www.ask-codey.com/glossary/stored-procedure