Stored Procedure in SQL

A stored procedure in SQL is a set of SQL statements that can be stored and reused. Stored procedures allow for more complex logic than individual SQL statements and can accept parameters, allowing them to be dynamic and reusable.

The general syntax for creating a stored procedure is as follows:

SQL Syntax

CREATE PROCEDURE procedure_name 
AS
BEGIN
    -- SQL statements
END; 

Example: Let's create a stored procedure that retrieves all employees from the employees table.

Table: employees

Create a simple Stored Procedure

SQL

CREATE PROCEDURE GetAllEmployees
AS
BEGIN
    SELECT * FROM employees;
END;   

To execute the stored procedure:

SQL