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 0

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