Your application contains a stored procedure for each country. Each stored procedure accepts an employee identification n

umber through the @EmpID parameter.

You need to build a single process for each employee that will execute the appropriate stored procedure based on the country of residence.

Which approach should you use?

A. A SELECT statement that includes CASE

B. Cur

sor

C. BULK INSERT

D. View

E. A user-defined function

Explanation:

SQL Server user-defined functions are routines that accept parameters, perform an action, such as a complex calculation, and return the result of that action as a value. The

return value can either be a single scalar value or a result set.