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 theIsDeleted column for the UserLogin table to 1 if the value of the Id
column for the UserLogin table is equal to 1.
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:
