Question

Write an INSERT statement that adds a row to the InvoiceCopy table with the following values: VendorID: 32 InvoiceTotal: $434.58 TermsID: 2 InvoiceNumber: AX-014-027 PaymentTotal: $0.00 InvoiceDueDate: 11/8/06 InvoiceDate: 10/21/06 CreditTotal: $0.00 PaymentDate: null

Answer 1

INSERT INTO InvoiceCopy (VendorID, InvoiceTotal, TermsID, InvoiceNumber, PaymentTotal, InvoiceDueDate, InvoiceDate, CreditTotal, PaymentDate) VALUES(32, 434.58, 2, ‘AX-014-027’, 0.00, ‘11/8/06’, ‘10/21/06’, 0.00, NULL)