SQL cursor Format

Declare adeclare bdeclare Cdeclare ... Declare cursor_name Cursor--declares a cursor for (SELECT * from table)   queries an arranged table open cursor_name        opens a cursor fetch NEXT from CURSOR_ Name   moves the cursor down, into @a,@b,@c  ..... Get data into the previously defined variable @a,@b,@c ..... Medium while @ @FETCH_STATUS = 0--Determine if data was successfully obtained Begin         .... .......     ....... FETCH NEXT from Cursor_name  --Move cursor down endclose cursor_name    --close cursor deallocate cursor_name--Release cursor

　　

SQL cursor Format