Which four Transact-SQL segments should you use to develop the solution?

DRAG DROP
You are developer for a Microsoft Azure SQL Database instance.
You are creating a new stored procedure. The procedure must perform the following tasks in this order:
1. Update a table named OrderHistory.
2. Delete rows from a table named Orders.
3. Delete rows from a table named Customers.
4. Insert rows into a table named ProcessHistory.
You need to ensure that the procedure meets the following requirements:
If either DELETE operation fails, the rest of operation must continue.
If either the UPDATE operation or the INSERT operation fails, the whole procedure should fail and no changes should be retained.
Which four Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order.
Select and Place:

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.