Question: Write a script that creates and calls a stored procedure named spInsertProduct that inserts a row into the Products table. This stored procedure should accept

Write a script that creates and calls a stored procedure named spInsertProduct that inserts a row into the Products table. This stored procedure should accept five parameters. One parameter for each of these columns: CategoryID, ProductCode, ProductName, ListPrice, and DiscountPercent. This stored procedure should set the Description column to an empty string, and it should set the DateAdded column to the current date. If the value for the ListPrice column is a negative number, the stored procedure should raise an error that indicates that this column doesnt accept negative numbers. Similarly, the procedure should raise an error if the value for the DiscountPercent column is a negative number. Code at least two EXEC statements that test this procedure. (Language is in SQL server)

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!

(10 Points) Write a script that creates and calls a stored procedure named spInsertProduct that inserts a row into the Products table. This stored procedure should accept five parameters. One...

Stored Procedures (20) 1 4 ) Write a script that creates and calls a stored procedure named spInsertProduct that inserts a row into the Products table. This stored procedure should accept five...

using SQL Server. Myguitarshop database. 1.Write a script that creates and calls a stored procedure named spInsertProduct that inserts a row into the Products table. This stored procedure should...

Chapter 15 How to code stored procedures, functions, and triggers Exercises 1. Write a script that creates and calls a stored procedure named spInsertCategory. First, code a statement that creates a...

Exercises 1 . 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...

HW EXERCISES: PROCEDURES, FUNCTIONS, TRIGGERS In this exercise you will create scripts in the Murach College database. 1 . Write a script that creates and calls a stored procedure named...

You will use SQL and My Guitar Shop database to create SQL statements. Save your select statements as a script. Place the semicolon at the end of each SQL statement. Please number your answers from 1...

creating a sql for the guitar shop You will use SQL and My Guitar Shop database to create SQL statements. Save your select statements as a script. Place the semicolon at the end of each SQL...

--cannot be canceled or amended without the beneficiary's consent. Select one: O a. Drafts O b. Letters of Credit O c. Revocable letter of credit O d. Irrevocable letter of credit

The following diagram shows the supply and demand for cupcakes (with quantity measured in dozens). a. Suppose the government imposes a new sales tax of $6 per dozen cupcakes. What will the new price...

What are the variables that must be considered when a corporation uses the option pricing model?

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

1. What can HR professionals do to mitigate concerns about pregnancy discrimination in the workplace? What does the law say companies need to do to avoid violating the rights of pregnant employees?

2. If you were an HR manager at UPS, how would you have handled the situation described in the case? How could the employees immediate manager have handled the situation differently?

LO2 Identify components of workflow analysis.