[转]Sql Server遍历表记录

declare @temp table
(
   [id] int IDENTITY(1,1),
   [Name] varchar(10)
)
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