把表中的数据一条条查出，并放到临时表中

declare @i int=0
create table #S
(
 sid int identity primary key,
 sname varchar(50)
)
while(@i<=(select top 1 sid from student order by sid desc))
begin
set @i=@i+1
if exists(select * from student where sid=@i)
begin
declare @sname varchar(50)
select @sname=sname from student where sid=@i
insert into #S values(@sname)
end
else
begin
set @i=@i
end
end
select * from #S
drop table #S