Chapter 8, Problem 7RQ

Explanation of Solution

Stored procedures:

• A stored procedure is a collection of procedural and SQL statements.
• It may have input parameter, ou...

Explanation of Solution

Purpose of stored procedure:

• It reduces code duplication by implementing a code isolation and code sharing techniques. Hence, it minimizes the error and also minimizes the cost required for application development and maintenance.
• Stored procedure reduces network traffic and also increases performance.

Example code for stored procedure:

Code to create a stored procedure:

CREATE PROCEDURE SW_Supply as select S...