如何在SQLSERVER2005中利用游标更新数据

--利用游标更新数据

--声明游标

DECLARE CursorL21 CURSOR FOR SELECT GUID, RUNIT FROM L21

--打开游标

OPEN CursorL21;

--声明变量

declare @GUID CHAR(36)

DECLARE @UCODE NVARCHAR(11)

FETCH NEXT FROM CursorL21 into @GUID, @UCODE

WHILE(@@FETCH_STATUS=0)

 BEGIN

  PRINT @GUID

  UPDATE L21 SET [email protected] WHERE [email protected]

  fetch next from CursorL21 into @GUID, @UCODE

 END

fetch next from CursorL21 into @GUID, @UCODE

print @GUID

CLOSE CursorL21

DEALLOCATE CursorL21