Câu 10: 70-761: Querying Data with Transact-SQL

DRAG DROP -You have two tables named UserLogin and Employee respectively. You need to create a Transact-SQL script that meets the following requirements: ✑ The script must update the value of the IsDeleted column for the UserLogin table to 1 if the value of the Id column for the UserLogin table is equal to1. ✑ The script must update the value of the IsDeleted column of the Employee table to 1 if the value of the Id column is equal to 1 for the Employee table when an update to the UserLogin table throws an error. ✑ The error message "No tables updated!" must be produced when an update to the Employee table throws an error. Which five Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the correct order. Select and Place:

1. A. Lựa chọn A bằng hình ảnh — đáp án hiện tại