write a stored procedure in Microsoft SQL Server that deletes an order given bt its ID, if
Fantastic news! We've Found the answer you've been seeking!
Question:
write a stored procedure in Microsoft SQL Server that deletes an order given bt its ID, if the status of the order is "new" . If the order does not exist or the status is not "new", then throw an error. You only need to delete the order record; no need to take care of any items belonging to the order. You need to protect the execution of the stored procedure from inconsistencies caused by concurrent modification. Give the T-SQL code to create this stored procedure.
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date: