Business Analyst: What is a stored procedure?

Stored procedure — precompiled SQL code stored in database.

Purpose:

• Reusable logic.
• Performance improvement.
• Security (controlled access).

Example:

1CREATE PROCEDURE GetCustomerOrders(IN cust_id INT)
2BEGIN
3  SELECT * FROM orders WHERE customer_id = cust_id;
4END;
5
6-- Call procedure
7CALL GetCustomerOrders(123);

Benefits:

• Code reusability.
• Network efficiency.
• Security.

BA relevance:

• Understand business logic.
• Define requirements.
• Validate implementation.