Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals. You need to create a stored procedure that updates the Customer, CustomerInfo, OrderHeader, and OrderDetails tables in order. You need to ensure that the stored procedure:- Runs within a single transaction.Commits updates to the Customer and CustomerInfo tables regardless of the status of
updates to the OrderHeader and OrderDetail tables.- Commits changes to all four tables when updates to all four tables are successful.Solution: You create a stored procedure that includes the following Transact-SQL segment:
Does the solution meet the goal?
A. Yes
B. No
Answer: B
