DRAG DROP
You need to create a cursor that meets the following requirements:
– Executes as quickly as possible.
– Reflects all data changes made to the table while scrolling.
Which five Transact-SQL statements should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact-SQL segments to the answer are and arrange them in the correct order.
Answer:
Explanation:
Step 1: Declare variables.
Step 2: Open the cursor
Step 3: Fetch the first instance.
Step 4: Loop
Step 5: Close and deallocate the cursor References: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/declare-cursor-transact
sql?view=sql-server-2017