Câu 55: 70-762: Developing SQL Databases

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?

1. A. Yes — đáp án hiện tại
2. B. No