Murachs MySQL 3rd Edition Chapter 14 Exercise 1 and 2

Availability: In stock

Regular Price: $12.00

Special Price: $10.00

OR

Murach's MySQL 3rd Edition Chapter 14 Exercise 1

Double click on above image to view full picture

Zoom Out
Zoom In

More Views

Quick Overview

Murach's MySQL 3rd Edition Chapter 14 Exercise 1 and 2


1. Write 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.


2. Write a script that creates and calls a stored procedure named test. This procedure should include a set of two SQL statements coded as a transaction to delete the row with an invoice ID of 114 from the Invoices table. To do this, you must first delete all line items for that invoice from the Invoice_Line_Items table.
If these statements execute successfully, commit the changes. Otherwise, roll back the changes.

Regular Price: $12.00

Special Price: $10.00

Details

Murach's MySQL 3rd Edition Chapter 14 Exercise 1 and 2

1. Write 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.

2. Write a script that creates and calls a stored procedure named test. This procedure should include a set of two SQL statements coded as a transaction to delete the row with an invoice ID of 114 from the Invoices table. To do this, you must first delete all line items for that invoice from the Invoice_Line_Items table.
If these statements execute successfully, commit the changes. Otherwise, roll back the changes.

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.