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 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

microsoft-exams

4 thoughts on “Which approach should you use?

  1. 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. ‘

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.