What is SQL Stored Procedure?

A SQL Stored Procedure is a precompiled collection of one or more SQL statements that are stored in a database server. Stored procedures can accept input parameters and return output parameters, and they can be called from applications or other stored procedures. They are used to encapsulate complex business logic, improve performance, and enhance security by granting access to specific database operations without exposing underlying tables.