Exam 70-461 topic 1 question 168 discussion

You have a Microsoft SQL Server database. You create tables by running the following Transact-SQL statements:

You need to create a stored procedure that meets the following requirements:
✑ Creates orders based on a customer's email address.
✑ Creates the order entry, and then adds the customer relationship.
✑ If any step fails during the process, all changes are reserved.
Which Transact-SQL statement should you run?
A.

B.

C.

D.