Your application contains a stored procedure 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 approach should you use?
A.
A recursive stored procedure
B.
Trigger
C.
An UPDATE statement that includes CASE
D.
Cursor
E.
The foreach SQLCLR statement