MS SQL Server - Cursor Template

DECLARE @Reg VARCHAR(255)

DECLARE MY_CURSOR CURSOR LOCAL STATIC READ_ONLY FORWARD_ONLY

FOR

SELECT Reg_NombreCorto FROM REGIONAL

OPEN MY_CURSOR

FETCH NEXT FROM MY_CURSOR INTO @Reg

WHILE @@FETCH_STATUS = 0

BEGIN

    --mi code ini

    PRINT @Reg

    --mi code fin

    FETCH NEXT FROM MY_CURSOR INTO @Reg

END

CLOSE MY_CURSOR

DEALLOCATE MY_CURSOR

GO