Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started