Which approach should you use?

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?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *