Question: When Josh was testing some code to handle large packages ( any package weighing over 9 0 . 0 lbs ) he somehow ran some

When Josh was testing some code to handle large packages (any package weighing over 90.0 lbs ) he somehow ran some statements that updated multiple records in the Package table and now the data is all messed up. He thinks he fixed the issue but needs a fresh set of data to re-test his code. Create a multi-table DELETE statement that would remove all the records in both the Package and ManifestPackage table.
When you test your DELETE statement you'll need to run the GenData_Packages Store Procedure to re-build the table contents after it is cleared, which will use the FlightReservation table to identify flights transporting packages.
When Josh was testing some code to handle large

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!