Computer Science > Report > Syracuse University - CSE 581Lab 9 (All)

Syracuse University - CSE 581Lab 9

Document Content and Description Below

4/15/2018 Lab 9: Transactions, Locking 1. Write a set of action queries coded as a transaction to reflect the following change: United Parcel Service has been purchased by Federal Express Corporati... on and the new company is named FedUp. Rename one of the vendors and delete the other after updating the VendorID column in the Invoices table. https://www.coursehero.com/file/38552332/Lab-9docx/ This study resource was shared via CourseHero.comFirst, I wrote a select statement to check the Vendor ID’s of the United Parcel Service and the Federal Express Corporation. They were 122 and 123 respectively. I wrote action queries to modify United Parcel Service as Federal Express Corporation. To begin the transaction, I used the BEGIN TRAN statement. Then, I wrote an update statement to set VendorID 123 as VendorID 122. Next, I deleted from Vendors, United Parcel Service which has an ID of 122. Then, I updated the Vendors table to set the vendor name as FedUP for all Vendors with a vendor ID of 123. Lastly, I ended the transaction with a COMMIT TRAN statement [Show More]

Last updated: 2 years ago

Preview 1 out of 5 pages

Buy Now

Instant download

We Accept: