循环遍历表变量
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