How should you complete Transact-SQL statement?

HOTSPOT
You have the following Transact-SQL statement:
DELETE FROM Person
WHERE PersonID = 5
You need to implement error handling.
How should you complete Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

microsoft-exams

One thought on “How should you complete Transact-SQL statement?

  1. Missing the following part on the image :

    END CATCH — should be in a selection dropdown box as well
    IF @@TRANCOUNT > 0
    COMMIT TRANSACTION

Leave a Reply

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


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