Business > CASE STUDY > 530-hw6.docx HW6 Advanced Database Management Systems Module 5: HW6 1. Write a set of (All)
530-hw6.docx HW6 Advanced Database Management Systems Module 5: HW6 1. Write a set of
Document Content and Description Below
530-hw6.docx HW6 Advanced Database Management Systems Module 5: HW6 1. Write a set of action queries as transactions to make the following changes: United Parcel Service has been purchased by FedX... and a new company is named FedUP.Rename one of the VENDORS AND DELETE THE OTHER AFTER UPDATING VendorID in the Invoices Table. CODE: USE AP; Go select * from vendors where VendorName = 'FedUP'; select * from Invoices where VendorID =122 OR VendorID = 123; BEGIN TRY BEGIN TRANSACTION DECLARE @oldcompanyint ,@newcompanyint SET @oldcompany= (select VendorID from Vendors where VendorName= 'United Parcel Service') SET @newcompany= (select VendorID from Vendors where VendorName= 'Federal Express Corporation') Update Invoices set VendorID = @newcompanywhere VendorID = @oldcompanydelete from vendors where VendorID = @oldcompany update Vendors set VendorName = 'FedUP' Where VendorName = 'Federal Expres. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [Show More]
Last updated: 2 years ago
Preview 1 out of 35 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$10.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Jul 22, 2021
Number of pages
35
Written in
Additional information
This document has been written for:
Uploaded
Jul 22, 2021
Downloads
0
Views
64
