Câu 66: 70-461: MCSA Querying Microsoft SQL Server 2012/2014

SIMULATION -You need to execute an UPDATE statement that modifies a subset of rows in a table. The rows affected by the UPDATE statement must only be committed if the row count criteria is met. Part of the correct Transact-SQL has been provided in the answer are below. Enter the code in the answer area that resolves the problem and meets the stated goals or requirements. You can add code within the code that has been provided as well as below it. Use the "˜Check Syntax' button to verify your work. Any syntax or spelling errors will be reported by line and character position.

1. A. Please review the explanation part for this answer. 1. DECLARE @ExprectedRowCount int = 82. 3. BEGIN TRAN OrderUpdate4. 5. UPDATE dbo.OrderHeader6. SET PromisedDate = DATEADD(dd, 5, PromisedDate)7. WHERE CustomerID = 84328. AND Shipped =09. 10. If @@RowCount = @ExpectedRowCount11. 12. COMMIT OrderUpdate13.14. else15. 16. ROLLBACK OrderUpdateOn line 3 add: BEGIN TRAN -On line 12 add: COMMIT -On line 16 add: ROLLBACK -References:https://docs.microsoft.com/en-us/sql/t-sql/language-elements/begin-transaction-transact-sql — đáp án hiện tại