Exam 70-461 topic 1 question 156 discussion

DRAG DROP -
You need to create a stored procedure that enters values into multiple tables. The solution must ensure that if a single insert fails, none of the values are inserted into the tables.
How should you complete the stored procedure? To answer, drag the appropriate values to the correct locations. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:

Suggested Answer:
References:
https://msdn.microsoft.com/en-us/library/ms188378.aspx