MSSQL cursor (cursor) Notes

Cursor note Declare   @ TMP   Varchar ( 15 ) -- Define Variables

Declare Cursor_data Cursor   For   Select Rulenumber From Rules -- Standing cursor

Open Cursor_data -- Enable cursor

Fetch   Next   From Cursor_data Into   @ TMP   -- Start Query
While   @ Fetch_status = 0   -- Determine whether the cursor ends
Begin
Print   @ TMP   -- Print Variables
-- The statement executed here
Fetch   Next   From Cursor_data Into   @ TMP   -- Next cursor
End
Close Cursor_data -- Close cursor
Deallocate Cursor_data -- Destroy cursor