Transaction control procedure
Transaction control***
Create a stored procedure with the following requirements:
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper Now Accept input that identifies the customer, the ISBN for one book, and the quantity being ordered. CHALLENGE — try this for two books instead of one
Create an ORDER record that reflects today’s date as the OrderDate.
Create an OrderItem record for the book(s) being ordered, reduce the (quantity on hand) appropriately for the ordered book, and either:
Return an error message if there is not sufficient inventory for the book ordered.
OR
Commit the transaction
Leave the shipping information null (there will be a separate process for shipping information).
Remember that the Order# is a unique, sequential key.
