SQL游标怎么循环更新
发布网友
发布时间：2022-04-08 03:22
共2个回答
热心网友
时间：2022-04-08 04:52
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 还是没有更新到临时表中去啊
热心网友
时间：2022-04-08 06:10
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
