sql 遍历结果集

declare @temp table 
( 
    [id] int IDENTITY(1,1), 
    [Name] varchar(10) 
) 
--select * from @temp 
declare @tempId int,@tempName varchar(10)

insert into @temp values('a') 
insert into @temp values('b') 
insert into @temp values('c') 
insert into @temp values('d') 
insert into @temp values('e')


--select * from @temp


WHILE EXISTS(select [id] from @temp) 
begin 
SET ROWCOUNT 1 
select @tempId = [id],@tempName=[Name] from @temp 
SET ROWCOUNT 0 
delete from @temp where [id] = @tempId

print 'Name:----'+@tempName 
end

  

posted @ 2015-11-04 10:51  gds111789  阅读(1519)  评论(0编辑  收藏  举报