Which four Transact-SQL statements should you use?

DRAG DROP
You administer a Microsoft SQL Server 2012 server that has a database named Contoso. The Contoso
database has a table named ProductPrices in a schema named Sales.
You need to create a script that writes audit events into the application log whenever data in the
ProductPrices table is updated.
Which four Transact-SQL statements should you use? (To answer, move the appropriate statements
from the list of statements to the answer area and arrange them in the correct order.)

DRAG DROP
You administer a Microsoft SQL Server 2012 server that has a database named Contoso. The Contoso
database has a table named ProductPrices in a schema named Sales.
You need to create a script that writes audit events into the application log whenever data in the
ProductPrices table is updated.
Which four Transact-SQL statements should you use? (To answer, move the appropriate statements
from the list of statements to the answer area and arrange them in the correct order.)

Answer:

Explanation:

http://msdn.microsoft.com/en-us/library/cc280386.aspx
http://msdn.microsoft.com/en-us/library/cc280448.aspx
http://msdn.microsoft.com/en-us/library/cc280404.aspx



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Roger

Roger

Agreed. That looks correct