Stored Procedures in SQL

 Stored Procedures in SQL

A stored procedure is a set of SQL statements that are stored in the database and can be executed on demand. Stored procedures can simplify complex operations and improve performance by reducing network traffic. Here's an example:

sql

CREATE PROCEDURE update_employee_age (IN employee_id INT, IN new_age INT)

BEGIN

    UPDATE employees

    SET age = new_age

    WHERE id = employee_id;

END;

In this example, we're creating a stored procedure called "update_employee_age" that takes two input parameters: employee_id and new_age. This procedure updates the age of the employee with the specified id.