sql 游标示例

 

DECLARE @field1 INT,@field2 VARCHAR(40), @field3 VARCHAR(40)

DECLARE myCur CURSOR 
FOR SELECT field1,field2,field3 FROM TABLE1 
OPEN myCur /* 打开游标 */ 

FETCH NEXT FROM myCur INTO @field1,@field2,@field3 /* 读取第1行数据*/ 
WHILE @@FETCH_STATUS=0 /* 用WHILE循环控制游标活动 */ 
    BEGIN 
    IF @field1=3
        BEGIN
            UPDATE TABLE1 SET @field2='test222' 
            WHERE CURRENT OF myCur 
        END
   
    FETCH NEXT FROM myCur INTO @field1,@field2,@field3  /* 在循环体内将读取其余行数据 */ 
    END 
CLOSE myCur           /* 关闭游标 */ 

DEALLOCATE  myCur    /* 删除游标 */