How should you complete the Transact-SQL statement?

DRAG DROP

You have the following table named Employees.

You need to calculate the employee _type value based on the hire date value.

How should you complete the Transact-SQL statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content-

NOTE: Each correct selection is worth one point.

View Answer

Answer: