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