Create a script that creates and calls a stored procedure named test. This procedure should include a
Fantastic news! We've Found the answer you've been seeking!
Question:
Create a script that creates and calls a stored procedure named test. This procedure should include a set of three SQL statements coded as a transaction to reflect the following change: United Parcel Service has been purchased by Federal Express Corporation and the new company is named FedUP. Rename one of the vendors and delete the other after updating the vendor_id column in the Invoices table.
If these statements execute successfully, commit the changes. Otherwise, roll back the changes.
Please do not use the @ symbol and use CALL test ();
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: