Which three Transact-SQL segments should you use to dev…

DRAG DROP
You have a table named HR.Employees as shown in the exhibit. (Click the exhibit button.)

You need to write a query that will change the value of the job title column to Customer Representative for any
employee who lives in Seattle and has a job title of Sales Representative. If the employee does not have a
manager defined, you must not change the title.
Which three 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:

DRAG DROP
You have a table named HR.Employees as shown in the exhibit. (Click the exhibit button.)

You need to write a query that will change the value of the job title column to Customer Representative for any
employee who lives in Seattle and has a job title of Sales Representative. If the employee does not have a
manager defined, you must not change the title.
Which three 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:

Answer:

Explanation:
https://msdn.microsoft.com/en-us/library/ms177523.aspx



Leave a Reply 1

Your email address will not be published. Required fields are marked *