Learning to use MS SQL Server cursors (cursor)

To be honest, using MS SQL Server for such a long time, cursors have not been used. Previous implementations of similar functionality were implemented using while loops plus temporary tables. Just a reference to the online sample exercise to write a bit. Learn about cursor concepts and syntax.

In the following code example,
First, declare that you need to use a variable in the cursor, that is, the data for the temporary storage processing field.
2. Declare a cursor and select the data set to be processed.
3. Open the cursor (#8行代码).
4. Fetch the NEXT data from the cursor to assign a value to the variable.
5. Loop @ @FETCH_STATUS = 0 condition.
6. In the loop block, the first record logic can be processed. In this example, print.
7. The logical processing is complete, and again fetch the NEXT data from the cursor to assign values to the variable. (same as above 4).
8. Close the cursor.
9. Delete and release the cursor.

Execution Result: