Microsoft
70-457 · Question #85
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…
The correct answer is D. Cursor. See the full explanation below for the reasoning.
Question
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?
Options
- Aa recursive stored procedure
- BTrigger
- CAn UPDATE statement that includes CASE
- DCursor
- EThe foreach SQLCLR statement
How the community answered
(21 responses)- C10% (2)
- D86% (18)
- E5% (1)
Community Discussion
No community discussion yet for this question.