Examples :Using simple cursor and syntax
DECLARE vend_cursor CURSOR
FOR SELECT * FROM Purchasing.Vendor
OPEN vend_cursor
FETCH NEXT FROM vend_cursor
Database interview questions and answers asked in various interviews, faqs,tutorial and articles..