Stored Procedures — Introduction

A stored procedure is a named block of SQL saved in the database. You CALL it instead of pasting the same query everywhere.

Stored Procedures — saved SQL on the server

A stored procedure is a named block of SQL saved in the database. You CALL it instead of pasting the same query everywhere.

Procedures can accept parameters, run multiple statements, and enforce business rules in one place.

Real-life example: A stored procedure is a vending machine button — press 'ClassAverage' and the school office runs the same report every time.

Syntax differs by database. Focus on the idea: reusable, parameterized SQL living on the server.

Simple procedure (MySQL style)

DELIMITER //
CREATE PROCEDURE GetStudentsByGrade(IN p_grade INT)
BEGIN
  SELECT student_id, full_name, city
  FROM students
  WHERE grade_level = p_grade;
END //
DELIMITER ;

CALL GetStudentsByGrade(10);

Simple procedure (SQL Server style)

CREATE PROCEDURE GetStudentsByGrade @Grade INT
AS
BEGIN
  SELECT student_id, full_name, city
  FROM students
  WHERE grade_level = @Grade;
END;

EXEC GetStudentsByGrade @Grade = 10;