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.

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

Updated September 27, 2026