What is a stored procedure?

Stored Procedure:

• Stored procedure is a group of SQL statements that forms a logical unit and performs a particular task.
• Stored Procedures are used to encapsulate a set of operations or queries to execute on database.
• Stored procedures can be compiled and executed with different parameters and results and may have any combination of input/output parameters.