Question: Using the My Guitar Shop database you installed in Module 1 , develop the following queries. Write a script that creates and calls a stored

Using the My Guitar Shop database you installed in Module 1, develop the following queries.
Write a script that creates and calls a stored procedure named insert_category.
First, code a statement that creates a procedure that adds a new row to the Categories table. To do that, this procedure should have one parameter for the category name.
Code at least two CALL statements that test this procedure. (Note that this table doesnt allow duplicate category names.) Execute the query and take a screenshot of the query and the results.

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!