What is a Stored Procedure?

Stored procedure refers to the routine available when using a relational database system.  Stored procedure is also called Proc, Sproc, SP or StoPro.  They are usually available within a data dictionary. Most stored procedures are used for data validation.  Data validation is integrated within a database.  Stored procedure is also used to unite as well as integrate logic in implementing applications.  For more complex procedures that require SQL statements, the use of stored procedures will definitely be an advantage.  All applications under stored procedure will [...]