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

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

Question

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

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

Accepted Answer

D. CREATE TRIGGER TrgPriceChange ON Products FOR UPDATE AS

Answer

A. CREATE TRIGGER TrgPriceChange ON Products FOR UPDATE AS

Answer

B. CREATE TRIGGER TrgPriceChange ON Products FOR UPDATE AS

Answer

C. CREATE TRIGGER TrgPriceChange ON Products FOR UPDATE AS

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