Which three Transact-SQL segments should you use to develop the solution?

Posted by: Pdfprep Category: 70-761 Tags: , ,

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.

Answer:

Explanation:

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

Leave a Reply

Your email address will not be published.