Your application contains a stored procedure for each country. Each stored procedure accepts an employee identification number 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. Cursor
C. BULK INSERT
D. View
E. A user-defined function
Single process = A user-defined function
Answer E:
The answer is B. Cursor.
‘ A cursor is declared by defining the SQL statement. Opening Cursor. A cursor is opened for storing data retrieved from the result set. Fetching Cursor. When a cursor is opened, rows can be fetched from the cursor one by one or in a block to do data manipulation. ‘
sorry answers is B
answers is C