You develop a Microsoft SQL Server 2012 database that contains a table named Customers. The Customers table has the following definition:

You need to create an audit record only when either the MobileNumber or HomeNumber column is updated. Which Transact-SQL query should you use?

Question

You develop a Microsoft SQL Server 2012 database that contains a table named Customers. The Customers table has the following definition:

You need to create an audit record only when either the MobileNumber or HomeNumber column is updated. Which Transact-SQL query should you use?

Accepted Answer

D. CREATE TRIGGER TrgPhoneNumberChange

Answer

A. CREATE TRIGGER TrgPhoneNumberChange

Answer

B. CREATE TRIGGER TrgPhoneNumberChange

Answer

C. CREATE TRIGGER TrgPhoneNumberChange

You develop a Microsoft SQL Server 2012 database that contains a table named Customers. The Customers table has the following definition: You need to create an audit record only when either the…