34,588
社区成员
发帖
与我相关
我的任务
分享
--声明游标
declare cur_d cursor for
select customerid
from orders --目标表orders
where customerid is not null --目标字段customerid
group by customerid;
declare @n char(5);
open cur_d;
fetch next from cur_d into @n;
select top 1 *
into #bala
from orders
where customerid = @n;
print 1
print @n
select *
from #bala;
select @@FETCH_STATUS
while @@FETCH_STATUS = 0
begin
fetch next from cur_d into @n;
print 2
print @n;
insert into #bala
select top 1 *
from orders
where customerid = @n;
select *
from #bala;
select @@FETCH_STATUS
end;
select *
from #bala;
drop table #bala;
close cur_d;
deallocate cur_d;
fetch next from cur_d into @n;
while @@FETCH_STATUS = 0
begin
insert into #bala select top 1 * from orders where customerid = @n;
fetch next from cur_d into @n;
end;
[Quote=引用 5 楼 bala7229291 的回复:]while @@FETCH_STATUS = 0
begin
print 2
print @n;
insert into #bala
select top 1 *
from orders
where customerid = @n;
select *
from #bala;
select @@FETCH_STATUS
fetch next from cur_d into @n;
end;