The Versatile Geek

A Stored Procedure is a group of sql statements that has been created and stored in the database. Advantages It is actually stored in the database data dictionary and Pre compiled one. We can call any number of times from our program.  Reduce the need to encode the logic elsewhere in client programs. Stored procedure will reduce network traffic and increase the performance. Consider if we have repeat statements to call then how many times we have to call Database better a single stored procedure can use for all the statements and a single call is enough instead of multiple calls. A single procedure can be used over the network by several clients using different input data.  If we modify stored procedure all the clients will get the updated stored procedure. Security - Stored Procedure can be granted access rights to the database that users who execute those procedures do not directly have. Stored Procedure can be use