用游标吧?
declare @a int,@b char(10),@c ...
declare cur cursor for select A,B,C ... from table1
open cur
fetch next from cur into @a,@b,@c...
while @@fetch_status = 0
begin
...(此处加入你的处理代码)
fetch next from cur into @a,@b,@c...
end
close cur
deallocate cur
declare @a int,@b char(10),@c ...
declare cur cursor for select A,B,C ... from table1
open cur
fetch next from cur into @a,@b,@c...
while @@fetch_status = 0
begin
...(此处加入你的处理代码)
fetch next from cur into @a,@b,@c...
end
close cur
deallocate cur
declare my_cursor cursor
for select A,B,C from TABLE
open my_cursor
fetch next from my_cursor into @A,@B,@C
while(@@FETCH_STATUS=0)
begin
print @A
print @B
print @C
fetch next from my_cursor into @A,@B,@C
end
close my_cursor
deallocate my_cursor
A
B
C
:
:
放到@A,@B,@C...
不用游标可以吗?
declare @A varchar(20),@B varchar(20),@C varchar(20)
select @A=A,@B=B,@C=C from t where ...
print @A
print @B
print @C如果连接所有记录则:
declare @A varchar(20),@B varchar(20),@C varchar(20)
set @A=''
set @B=''
set @C=''
select @A=@A+A+',',@B=@B+B+',',@C=@C+C+',' from t where ...
print @A
print @B
print @C
declare @N int
set @N=1
select identity(int,1,1) id ,a,b,c into #tmp from yourtable
while @N<10
begin
select @A=a,@b=b,@c=c from #tmp where id=@N
print @a
print @b
print @c
set @N=@n+1
end
drop table #tmp
@b = (Select top 1 field from (Select top 2 field from 表) order by field desc),
@c = (Select top 1 field from 表 order by field desc)