Learning to use MS SQL Server cursors (CURSOR) _mssql

To be honest, the cursor has not been used for a long time using MS SQL Server. Similar functions were previously implemented using a while loop plus a temporary table. Just had a reference to the online example practice to write. Learn about cursor concepts and syntax.

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



Execution results: