Question: Stored Procedure 5. (10) Write a stored procedure named find Average sales. The procedure does not have any parameter variable (accepts no arguments) but returns

 Stored Procedure 5. (10) Write a stored procedure named find Average
sales. The procedure does not have any parameter variable (accepts no arguments)

Stored Procedure 5. (10) Write a stored procedure named find Average sales. The procedure does not have any parameter variable (accepts no arguments) but returns the average sales value using an output parameter. You can use the code from exercise 1 to write the code inside the procedure. (5) Code an EXEC statement to call/test this procedure and print the return value. 6. (10) Write a stored procedure named spinsertCategory. The procedure has one parameter variable (accepts one argument), which is the name of the new category that you want to insert in the Categories table and returns nothing. If the insert is successful, the procedure should print that the insert was successful. If the insert was not successful, the procedure should print that the insert failed. (5) Code one EXEC statement that calls/tests this procedure with a valid category name. (5) Code another EXEC statement that calls/tests this procedure with an invalid category name. Note that this table doesn't allow duplicate category names. Stored Procedure 5. (10) Write a stored procedure named find Average sales. The procedure does not have any parameter variable (accepts no arguments) but returns the average sales value using an output parameter. You can use the code from exercise 1 to write the code inside the procedure. (5) Code an EXEC statement to call/test this procedure and print the return value. 6. (10) Write a stored procedure named spinsertCategory. The procedure has one parameter variable (accepts one argument), which is the name of the new category that you want to insert in the Categories table and returns nothing. If the insert is successful, the procedure should print that the insert was successful. If the insert was not successful, the procedure should print that the insert failed. (5) Code one EXEC statement that calls/tests this procedure with a valid category name. (5) Code another EXEC statement that calls/tests this procedure with an invalid category name. Note that this table doesn't allow duplicate category names

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!