Write a script that creates and calls a stored procedure

Assignment Help Computer Engineering

Reference no: EM132174987

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 accept five parameters/arguments. One parameter/argument for each of these columns:

CategoryID (int), ProductCode (varchar), ProductName (varchar), ListPrice (smallmoney), and DiscountPercent (decimal). 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 doesn't 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.

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

Reference no: EM132174987

Questions Cloud

Using sql developer create user user : As user1 update the last name of the customer with customer ID 188. Explain results.

Basis for classifying the hibiscus flower : Carolus Linnaeus wanted to classify the hibiscus flower. He began by examining the color of the flower, its petal shape, its petal numbers, and the arrangement

How much revenue did the company that entered : If the company whose product entered the market on time earned a total revenue of $25 million.

Did the geneticist isolate the wrong dna : Upon comparison she notes that the DNA sequence is 1000bp longer than the mRNA sequence. Did the geneticist isolate the wrong DNA?

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

Cellular respiration and for anaerobic respiration : If the one molecule of ATP releases 30.5 kJ/mol or 7.3 kcal/mol, calculate the theoretical efficiency (showing your work) for cellular respiration

Create a trigger for auditing : Create a trigger for auditing ?create trigger audit_customers on the Custoners table.

What could we conclude about those results : After boiling the saliva and adding the starch, we added 5 drops of HCL and incubated the tube in an ice bath before testing for the presence of maltose.

Questions for animal adaptations : What are detrivores What are substrate feeders What is another name for a suspension feeder:

User Account

All Pages