SQL Serverカーソル使用例

DECLARE @id varchar(50) 
DECLARE @value varchar(2000) 
DECLARE My_Cursor CURSOR --    
FOR (SELECT id,value FROM table1 where id > 100) --            
OPEN My_Cursor; --    
FETCH NEXT FROM My_Cursor INTO @id,@value; --       ( table1   id、value  @id、@value   )
WHILE @@FETCH_STATUS = 0
    BEGIN
		PRINT @id	--    id
		PRINT @value	--    value
        FETCH NEXT FROM My_Cursor INTO @id,@value; --       ( table1   id、value  @id、@value   )
    END
CLOSE My_Cursor; --    
DEALLOCATE My_Cursor; --    
GO