# Write a script that creates and calls a stored procedure named spInsertProduct that inserts a row...

###### 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 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 doesn’t 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)

#### Similar Solved Questions

##### We learned that share value maximization is the ultimate goal of a firm in the market...
We learned that share value maximization is the ultimate goal of a firm in the market economy? How does this seemingly selfish goal benefit the entire society?...
##### A particle's trajectory is described by = (}t - 2t2) m and y 2)m, where t...
A particle's trajectory is described by = (}t - 2t2) m and y 2)m, where t is ins. Part A You may want to review (Pages 81 - 85) What is the particle's speed at t = 0s? v 2 m/s Previous Answers Submit Correct Here we learn how to determine the speed at a given time from the expressions for co...
##### Refer to the News Wire to answer two questions NEWS WIRE EXTERNALITIES Secondhand Smoke Kills More...
Refer to the News Wire to answer two questions NEWS WIRE EXTERNALITIES Secondhand Smoke Kills More Than 600,000 people a Year: Study Secondhand smoke globally kills more than 600,000 people each year, accounting for 1 percent of all deaths worldwide, according to a new study. Researchers estimate th...
##### 2 pts A set of crash tests consists of running a test car, moving at a...
2 pts A set of crash tests consists of running a test car, moving at a speed of 12.2 m/s, into a solid wall. Strapped securely in an advanced seat belt system, a 69.0 kg dummy is found to move a distance of 0.900 m from the moment the car touches the wall until the time the car is stopped. Calculate...
##### How is the total cost of a progtamming language calculated?
how is the total cost of a progtamming language calculated?...
##### List several possible cost drivers that can be used by a cruise line such as Disney....
List several possible cost drivers that can be used by a cruise line such as Disney. List possible cost drivers that can be used by a company like Albertsons? Discuss research on least-squares regression method, discuss its advantages and disadvantages?...
##### (10 pts) Consider optimal global thresholding using Otsu's method to segment a digital image into two...
(10 pts) Consider optimal global thresholding using Otsu's method to segment a digital image into two classes Cị and C2. Otsu's method is optimum in the sense that it maximizes the between-class variance oß = P1(m1 – mg)2 + P2(m2 – mg)?, where Pi (i = 1, 2) is the pro...
##### 10. An object of mass m is thrown with initial velocity vo at an angle o...
10. An object of mass m is thrown with initial velocity vo at an angle o to the horizontal. The object strikes the ground after time t = t. Find: a. The change in object's momentum during its flight. b. The average value of the momentum during this time....
##### Assume that x is a normally distributed random variable with a mean of 70 and a...
Assume that x is a normally distributed random variable with a mean of 70 and a standard deviation of 10. Find the probability that x is greater than 75. Find Pix > 75). O 0.2345 O 0.4357 O 0.3085 0.3220...