Write a script that creates and calls a stored procedure


Write a script that creates and calls a stored procedure named spUpdateProductDiscount that updates the DiscountPercent column in the Products table. This procedure should have one parameter for the product ID and another for the discount percent.
If the value for the DiscountPercent column is a negative number, the stored procedure should raise an error that indicates that the value for this column must be a positive number.
Code at least two EXEC statements that test this procedure.

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Write a script that creates and calls a stored procedure
Reference No:- TGS081256

Expected delivery within 24 Hours