What is a Stored Procedure
They are one or more SQL programs stored in a database as an executable object. They can be called interactively, from within a client application or from another stored procedure and from within triggers. We can pass parameters to and return from stored procedures to increase their usefulness and flexibility. A stored procedure can return a number or result set and a status code. Advantage of using Stored Procedure: Modular Programming: Stored procedures are modular. This is a good thing from a maintenance standpoint. When query trouble arises in your application, you would likely agree that it is much easier to troubleshoot a stored procedure than an embedded query buried within many lines of GUI code. Function based access to tables: A user can have permissions to execute a stored procedure without having permission to operate directly on the underlying tables. Reduced network traffic: Stored procedures can consists of many individual SQL queries but...