Your application contains a stored proced

ure for each country. Each stored procedure accepts an employee identification number through the @EmpID parameter.

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

Which appro

ach should you use?

A. A recursive stored procedure

B. Trigger

C. An UPDATE statement that includes CASE

D. Cursor

E. The for each SQLCLR statement

Explanation: