What is Stored Procs?

A stored procedure is a set of SQL statements with an assigned name, which is stored in a relational database management system (RDBMS) as a group, so it can be reused and shared by multiple programs. They are used to encapsulate complex logic, improve performance by reducing network traffic, and enhance security by controlling data access. Stored procedures can accept input parameters and return output parameters or result sets.