Question no.2

You attempt to process an invoice by using usp_InsertInvoice.sql and you receive the following error message: "Msg 515, Level 16, State 2, Procedure usp_InsertInvoice, Line 10 Cannot insert the value NULL into column 'InvoiceDate', table 'DB1.Accounting.Invoices'; column does not allow nulls. INSERT fails." You need to modify usp_InsertInvoice.sql to resolve the error. How should you modify the INSERT statement?

A. InvoiceDate varchar(l00) 'InvoiceDate',

B. InvoiceDate varchar(100) 'Customer/InvoiceDate', '

C. InvoiceDate date '@InvoiceDate',

D. InvoiceDate date 'Customer/@InvoiceDate',

Correct Answer: C