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
Get step-by-step solutions from verified subject matter experts
