SQL Server 2005 te Update Cursor kullanımı

CREATE TABLE [dbo].[T_ORNEK](
[ID] [int] NULL,
[DEGER] [int] NULL
)
INSERT INTO T_ORNEK VALUES (1,NULL)
INSERT INTO T_ORNEK VALUES (3,NULL)

DECLARE @ID INT
DECLARE @X INT
SET @X = 1

DECLARE cur CURSOR FOR
select ID from T_ORNEK
FOR UPDATE
OPEN cur
FETCH NEXT FROM cur INTO @ID
WHILE @@FETCH_STATUS = 0
BEGIN
SET @X = @X*@X + @ID
UPDATE T_ORNEK SET DEGER = @X WHERE CURRENT OF CUR
FETCH NEXT FROM cuR INTO @ID
END
CLOSE cur
DEALLOCATE cur