Which Transact-SQL statement should you run?

You have a database that contains the following tables:

Customer

Customer Audit

Where the value of the CustomerID column equals 3, you need to update the value of the CreditLimit column to 1000 for the customer. You must ensure that the change to the record in the Customer table is recorded on the CustomerAudit table.

Which Transact-SQL statement should you run?
A .

B .

C .

D .

View Answer

Answer: D