--生成测试数据
create table 表1(name varchar(10),age int)
insert into 表1 select 'Michael',20
insert into 表1 select 'John ',23
insert into 表1 select 'Mary ',24
GO
--借助含自增列的表变量实现循环处理过程
declare @t table(id int identity(1,1),name varchar(10),age int)
declare @i int,@name varchar(10),@age int
set @i = 1
insert into @t select * from 表1
select @name=name,@age=age from @t where id=@i
while @@rowcount<>0
begin
print 'name='+@name+';age='+rtrim(@age)
set @i=@i+1
select @name=name,@age=age from @t where id=@i
end
go