SQL Server - Simple example of CURSOR

SQL Cursor is very handy to execute a loop in SQL, especially inside of a stored procedure.

Let's look at a simple example to understand how it works.

 USE AdventureWorks  
 GO  
 DECLARE @ProductID INT  
 DECLARE @getProductID CURSOR  
 SET @getProductID = CURSOR FOR  
 SELECT ProductID  
 FROM Production.Product  
 OPEN @getProductID  
 FETCH NEXT  
 FROM @getProductID INTO @ProductID  
 WHILE @@FETCH_STATUS = 0  
 BEGIN  
 PRINT @ProductID  
 FETCH NEXT  
 FROM @getProductID INTO @ProductID  
 END  
 CLOSE @getProductID  
 DEALLOCATE @getProductID  
 GO