Question: Stored Procedures (20) 1 4 ) Write a script that creates and calls a stored procedure named spInsertProduct that inserts a row into the Products

Stored Procedures (20)

14) 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/arguments. One parameter/argument for each of these columns: CategoryID (int), ProductCode (varchar), ProductName (varchar), ListPrice (smallmoney), and DiscountPercent (smallmoney).

In the procedure, validate the following:

If the value for the ListPrice column is a negative number, the stored procedure should throw an error (using THROW) that indicates that this column doesnt accept negative numbers. If the value for the DiscountPercent column is a negative number, the stored procedure should also throw a similar error (using THROW).

When inserting data into the Products table, set the Description column to an empty string and set the DateAdded column to the current date.

(6) Code at least two EXEC statements that test this procedure (one successful, one failure)

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

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

In SQL working on how to code stored procedures, functions, and triggers: 1.Write a script that creates and calls a stored procedure named spUpdateInstructor that updates the AnnualSalary column in...

4. Write a script that creates and calls a stored procedure named test. This stored procedure should create a cursor for a result set that consists of the product_name and list_price columns for each...

Exercises Write a script that creates and calls a stored procedure named test. This procedure should include two SQL statements coded as a transaction to delete the row with a customer ID of 8 from...

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

1. Write a script that creates and calls a stored procedure named test. This procedure should include two SQL statements coded as a transaction to delete the row with a customer ID of 8 from the...

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

What is the molecular formula of the following compound? Empirical formula: CH ( = 78.11 g/mol):

During the height of the financial crisis in September 2008, the Fed injected large amounts of reserves into banks, and in the next month, it started paying interest to banks on these reserves. Prior...

4. Which operating system component reads and executes programs?

Make 3 5 0 ml of a solution that is 2 5 mM Tris, 2 . 5 mM EDTA, and the pH is 8 . 0 . Tris is a base and the FW of Tris is 1 2 1 . 1 and EDTA is 1 8 7 . Do not make a volume that exceeds 3 5 0 mL

Assume that the banking system has total reserves of $100 billion. Assume also that required reserves are 10 percent of checking deposits and that banks hold no excess reserves and households hold no...

As shown in Figure 3, the overall labor-force participation rate of men declined between 1970 and 2000. At the same time, the labor-force participation rate of women increased sharply. This overall...

The Bureau of Labor Statistics announced that in February 2008, of all adult Americans, 145,993,000 were employed, 7,381,000 were unemployed, and 79,436,000 were not in the labor force. Use this...