Computers and Technology
Computers and Technology, 11.11.2019 21:31, synite

Create a trigger for the invoices table in the ap database that automatically inserts the vendor name for a paid invoice into a table named transactionsdone. the trigger should fire any time the paymenttotal column of the invoices table is updated. by updated, this means the value in the update query is different from the current value in the database. if the two values are the same, then no insert should be made into the transactionsdone table. also, make sure you add the current date using the getdate() function into the transactionsdone table. the structure of the transactiondone table is as follows: create table transactionsdone(vendorname varchar(50),currentdate datetime2)

answer
Answers: 2

Similar questions

Do you know the correct answer?
Create a trigger for the invoices table in the ap database that automatically inserts the vendor nam...

Questions in other subjects:

Konu
Chemistry, 15.02.2021 08:10
Konu
Spanish, 15.02.2021 08:10