stored procedure

Definitions

1. A precompiled program stored in the database that encapsulates SQL statements and procedural logic, executed by calling its name rather than sending raw SQL. Stored procedures can improve performance through precompilation, enforce business rules at the database layer, and reduce network round-trips. They're beloved by DBAs and mistrusted by application developers.

   In plain English: A mini-program that lives inside the database and runs SQL commands when you call it — like a recipe the database already knows by heart.

   Example: The legacy system has 400 stored procedures containing all the business logic, and the developers are terrified to change any of them because there are no tests.

Related Terms

• ORM
• Migration
• trigger
• Clause
• Database
• Dialect
• Procedure
• Subroutine
• CTE
• Window Function
• Lateral Join
• Join
• Join Table
• Knex
• Master-Slave
• Outer Join
• Partition
• Right Join
• Scan
• Subquery
• Write Lock
• MariaDB