What are Stored Procedures?
Stored procedures are saved SQL code you can run anytime.
Simple analogy: Like saving a recipe - write once, cook many times.
Example
Instead of writing this every time:
UPDATE products SET stock = stock - 1 WHERE product_id = 101;
UPDATE sales SET total_sold = total_sold + 1 WHERE product_id = 101;Save it as a procedure:
CREATE PROCEDURE sell_product(p_id INTEGER)
AS
BEGIN
UPDATE products SET stock = stock - 1 WHERE product_id = p_id;
UPDATE sales SET total_sold = total_sold + 1 WHERE product_id = p_id;
END;Use it:
CALL sell_product(101);Summary
Stored Procedure = Saved reusable SQL code Write once, use many times