标准游标语句

--删除语句declare test cursor forselect top 10 ID from test1 order by ID ascdeclare @ID nvarchar(10)open testfetch next from test into @IDwhile @@fetch_status=0begindelete from test1 where ID=@IDfetch next from test into @IDendclose testdeallocate test--更新UPDATE语句declare test cursor forselect top 50 ID from test1 order by ID declare @ID nvarchar(10),@ID2 intopen testset @ID2=0fetch next from test into @IDwhile @@fetch_status=0beginSET @ID2 = @ID2 + 1update test1set keyname=Cast(@ID2 as nvarchar(10))where ID=@IDfetch next from test into @IDendclose testdeallocate testgo