SQL

1. Write SELECT INTO statements to create two test tables named VendorCopy and InvoiceCopy that are complete copies of the Vendors and Invoices tables. If VendorCopy and InvoiceCopy already exist, first code two DROP TABLE statements to delete them.

2. 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

3. Write an INSERT statement that adds a row to the VendorCopy table for each non-California vendor in the Vendors table. (This will result in duplicate vendors in the VendorCopy table.)

Answer:

4. Write an UPDATE statement that modifies the VendorCopy table. Change the default account number to 403 for each vendor that has a default account number of 400.

5. Write an UPDATE statement that modifies the InvoiceCopy table. Change the PaymentDate to todays date and the PaymentTotal to the balance due for each invoice with a balance due. Set todays date with a literal date string, or use the GETDATE() function.