subject
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)

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 11:00
Lisa’s company, abc ltd., lost its biggest client and is now facing a financial crunch. most of her colleagues have resigned, but lisa decides to stay with the company and assist the management in overcoming the financial situation. which quality is lisa demonstrating? a. self-management b. cooperativeness c. responsibility d. loyalty
Answers: 2
question
Computers and Technology, 23.06.2019 00:30
Pl i need the answer now ! which one of the following is considered a peripheral? a software b mouse c usb connector d motherboard
Answers: 1
question
Computers and Technology, 23.06.2019 12:00
What type of slide show is a dynamic and eye-catching way to familiarize potential customers with what your company has to offer? a. ole b. photo album c. brochure d. office clipboard
Answers: 2
question
Computers and Technology, 23.06.2019 14:30
Select the correct answer. sean is a computer programmer. he has programmed an application for toddlers that plays nursery rhymes. however, a logic error has occurred in the program. which problem is a likely consequence of the error? a. the program crashes every time the user wants to play the nursery rhymes. b. the program crosses its buffer boundaries and overwrites an adjacent program. c. the program plays a different nursery rhyme than the one the user intended to play. d. the program shows different structures in its programming language code. e. the program introduces new viruses every time the user plays a nursery rhyme.
Answers: 1
You know the right answer?
Create a trigger for the invoices table in the ap database that automatically inserts the vendor nam...
Questions
question
History, 13.12.2021 19:20
question
English, 13.12.2021 19:20
question
Mathematics, 13.12.2021 19:20
Questions on the website: 13722367