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 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 retest his code. Create a multitable 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 GenDataPackages Store Procedure to rebuild the table contents after it is cleared, which will use the FlightReservation table to identify flights transporting packages.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
