Q&D cursor sample

Elementary cursor

DECLARE test_cursor CURSOR
READ_ONLY
FOR SELECT TOP 10
    SV.name
FROM
    master.dbo.spt_values AS SV;

DECLARE @name nvarchar(35)
OPEN test_cursor

FETCH NEXT FROM test_cursor INTO @name
WHILE (@@fetch_status = 0)
BEGIN
        PRINT @@FETCH_STATUS
		DECLARE @message nvarchar(100)
		SELECT @message = N'my name is: ' + @name
		PRINT @message
	FETCH NEXT FROM test_cursor INTO @name
END

CLOSE test_cursor
DEALLOCATE test_cursor
GO