KW Online Tools Zone
Online SQL/MS SQL create cursor query generator
No need to remember syntax and type required data and generate sql query online easy!
Enter required infomation below!
DECLARE ^cursor_name$ CURSOR
LOCAL SCROLL STATIC
FOR
^select_query$
 
OPEN ^cursor_name$

FETCH NEXT FROM ^cursor_name$
INTO ^cursor_variables$

WHILE @@FETCH_STATUS = 0
BEGIN
   FETCH NEXT FROM ^cursor_name$
   INTO ^cursor_variables$
   
END
CLOSE ^cursor_name$

DEALLOCATE ^cursor_name$
MYSQL Query Output
Copyright © 2014 Knowledge walls, All rights reserved