34,587
社区成员
发帖
与我相关
我的任务
分享
游标的基本写法
declare @id int,@name varchar(20);
declare cur cursor fast_forward for
select id,name from a;
open cur;
fetch next from cur into @id,@name;
while @@fetch_status=0
begin
--做你要做的事
fetch next from cur into @id,@name;
end
close cur;
deallocate cur;
--假设ID从1开始连续并不间断.
declare @i as int
select @i = count(1) from tb
declare @j as int
set @j = 1
while @j <= @i
begin
...你的处理语句
set @i = @i + 1
end