Esc
↑↓ navigate   Enter open   Esc close

Databases & SQL

Stored Procedure

/stɔːd prəˈsiːdʒər/

Definition

A pre-compiled SQL script stored in the database that can be called by name to execute a sequence of operations.

Example in context

"The nightly report runs a stored procedure — the logic lives in the database, not the application."

Related terms

  • Trigger — A database procedure that runs automatically when a specific event occurs (INSERT, UPDATE, DELETE) on a table.

Practice this term

Master Stored Procedure in context by working through exercises in the Databases & SQL module. You'll see the term used in real engineering scenarios with multiple-choice, fill-in-the-blank, and matching drills.

Practice in exercises → Browse all words

Frequently Asked Questions

What does "Stored Procedure" mean?

A pre-compiled SQL script stored in the database that can be called by name to execute a sequence of operations.

How do you pronounce "Stored Procedure"?

"Stored Procedure" is pronounced /stɔːd prəˈsiːdʒər/.

Can you use "Stored Procedure" in a sentence?

"The nightly report runs a stored procedure — the logic lives in the database, not the application."