SQL Stored Procedure

Introduction to Stored Procedure

• Stored Procedure is a set of Structured Query Language (SQL) statements.
• It is a subroutine available to applications that access a Relational Database Management System (RDBMS).
• Stored procedure is assigned with the name that's stored in the database in compiled form, so that it can be shared by a number of programs.
• It is helpful in controlling to access the data, preserving data integrity and improving productivity.

Advantages of a Stored Procedure

• Stored procedures are easier to maintain and troubleshoot as they are modular.
• It enables better tuning for performance.
• It is much easier from a GUI end than building/using complex queries.
• It helps in reducing the network usage.
• It provides more scalability to an application.
• It is reusable and hence reduces the code.