What is Store Procedure?

A stored procedure is a subroutine available to applications accessing a relational database management system (RDBMS). It's a group of SQL statements that form a logical unit and perform a specific task. Stored procedures are commonly used to encapsulate complex database operations, enforce business rules, improve performance, and enhance security by granting access to data through the procedure rather than direct table access.