循环遍历表变量

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')

WHILE EXISTS(select [id] from @temp)
begin
select top 1 @tempId = [id],@tempName=[Name] from @temp
delete from @temp where [id] = @tempId
print  'Name:----'+@tempName
end