Question: Create a trigger in the AP database for the Invoices table that automatically inserts the vendor name and address for a paid invoice into a

Create a trigger in the AP database for the Invoices table that automatically inserts the vendor name and address for a paid invoice into a table named ShippingLabels. The trigger should fire any time the PaymentTotal column of the Invoices table is updated. The structure of the ShippingLabels table is as follows:

CREATE TABLE ShippingLabels

( Vendorame

varchar(50,

VendorAddress1

varchar(50

VendorAddress2

varchar(50),

VendorCity

varchar(50),

VendorState

VendorZipCode

char(2),

varchar(20));

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 Databases Questions!