Stored Procedure

Overview

A Stored Procedure is a precompiled collection of SQL statements and procedural logic saved in the database.

Code Examples

SQL

CREATE PROCEDURE UpdateEmployeeSalary(emp_id_param INT, new_salary DECIMAL)
BEGIN
    UPDATE employees SET salary = new_salary WHERE emp_id = emp_id_param;
END;

Summary

Stored Procedures group operational SQL statements into reusable, server-side database subroutines.