Transaction control***
Create a stored procedure with the following requirements:
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.
