--
声明变量表@tb
declare @tb table (id int ,name varchar ( 50 ))
-- 添加测试数据
insert into @tb
select 6 , ' aa ' union all
select 7 , ' bb ' union all
select 8 , ' cc ' union all
select 9 , ' dd ' union all
select 10 , ' abc ' union all
select 11 , ' ddef ' union all
select 12 , ' fda ' union all
select 13 , ' rewr ' union all
select 14 , ' eyt ' union all
select 15 , ' jjy ' union all
select 16 , ' bbbxd ' union all
select 17 , ' xxx ' union all
select 18 , ' ffff ' union all
select 19 , ' wwwwwwww ' union all
select 20 , ' aaaaaaaaaa '
/*
查看表中数据
select * from @tb
*/
-- 声明循环用的“指针”
declare @min varchar ( 5 )
-- 赋初值
select @min = min (id) from @tb
-- 开始循环
while @min is not null
begin
print @min -- 打印当前“指针”的值
select @min = min (id) from @tb where id > @min -- 更新“指针”内容,使之移到下一记录
end
declare @tb table (id int ,name varchar ( 50 ))
-- 添加测试数据
insert into @tb
select 6 , ' aa ' union all
select 7 , ' bb ' union all
select 8 , ' cc ' union all
select 9 , ' dd ' union all
select 10 , ' abc ' union all
select 11 , ' ddef ' union all
select 12 , ' fda ' union all
select 13 , ' rewr ' union all
select 14 , ' eyt ' union all
select 15 , ' jjy ' union all
select 16 , ' bbbxd ' union all
select 17 , ' xxx ' union all
select 18 , ' ffff ' union all
select 19 , ' wwwwwwww ' union all
select 20 , ' aaaaaaaaaa '
/*
查看表中数据
select * from @tb
*/
-- 声明循环用的“指针”
declare @min varchar ( 5 )
-- 赋初值
select @min = min (id) from @tb
-- 开始循环
while @min is not null
begin
print @min -- 打印当前“指针”的值
select @min = min (id) from @tb where id > @min -- 更新“指针”内容,使之移到下一记录
end