Question

SQL游标怎么循环更新

怎么使用SQL游标更新临时表中'aa'字段下大于100条记录的数据

select a.OID,0 as ewaibutie into #aa from Man_FinishRecord a
当游标查询到的记录数大于100的时候#aa表中的ewaibutie 字段每一条都更新成5

求大神贴代码！
declare @ewaibutie int
declare @i int
set @i=0
declare cur_man cursor scroll dynamic
for
select ewaibutie from #aa
OPEN cur_man
FETCH NEXT from cur_man into @ewaibutie
WHILE @@FETCH_STATUS = 0
BEGIN
if(@i > 100)
begin
update #aa set @ewaibutie = 5
set @i = @i + 1
end
FETCH NEXT from cur_man into @ewaibutie
END
CLOSE cur_man
DEALLOCATE cur_man

结果没有任何变化，求解释

Answer 1

应该不是游标问题，是循环内的判定问题，@i一直没变过，所以 @i>100不会命中。将set @i提出来：
WHILE @@FETCH_STATUS = 0
BEGIN
set @i = @i + 1
if(@i > 100)
begin
update #aa set @ewaibutie = 5
end
FETCH NEXT from cur_man into @ewaibutie
END
CLOSE cur_man

追问

5 还是没有更新到临时表中去啊

Answer 2

应该不是游标问题，是循环内的判定问题，@i一直没变过，所以 @i>100不会命中。将set @i提出来：
WHILE @@FETCH_STATUS = 0
BEGIN
set @i = @i + 1
if(@i > 100)
begin
update #aa set @ewaibutie = 5
end
FETCH NEXT from cur_man into @ewaibutie
END
CLOSE cur_man