PrepAway - Latest Free Exam Questions & Answers

What is missing from the T-SQL statement below for crea…

What is missing from the T-SQL statement below for creating and using a cursor?
DECLARE mycursor CURSOR FOR SELECT * FROM Vendor FETCH NEXT FROM mycursor;

PrepAway - Latest Free Exam Questions & Answers

A.
KEYSET

B.
OPEN

C.
STATIC

D.
SCROLL

Explanation:
You need to open the CURSOR before you can call FETCH.


Leave a Reply