一个小问题

[jxncwzb]

while(select distinct ClassID from test)--如这里有十条
begin
--在循环时如何取ClassID的值
end

[CutBug]

Declare @id int --申明一个变量
select @id=ClassId from test

[dawugui]

while classid in (select distinct ClassID from test)

[jxncwzb]

谢谢,不过test2会出现100条记录,

insert into @test2 select ClassID from @test where ClassID=@tmp//改动

这样行吗

[jxncwzb]

while(select distinct ClassID from test)--如这里有十条
begin
--在循环时如何取ClassID的值,循环到第一条时取第一条ClassID的值,循环到第二条时取第二条ClassID的值……
end

[cnhzlyg]

while classid in (select distinct ClassID from test)

这样不行么。

_______________________________

回帖是种奉献!
给分是种回报!
欢迎光临:www.sodeer.com
_______________________________

[jxncwzb]

不行呀

[cnhzlyg]

declare @test table( ClassID varchar(10))
insert @test
select '1' union all
select '2' union all
select '3' union all
select '4' union all
select '5' union all
select '6' union all
select '7' union all
select '8' union all
select '9' union all
select '10'

select * from @test


declare @tmp varchar(10)
declare @test2 table( ClassID varchar(10))
declare cur cursor for select * from @test
open cur
fetch cur into @tmp
while (@@fetch_status=0)
begin
insert into @test2 select ClassID from @test
fetch cur into @tmp
end
close cur
deallocate cur

select * from @test2

结果:

表1 test1
ClassID
----------
1
2
3
4
5
6
7
8
9
10

表2 test2
ClassID
----------
1
2
3
4
5
6
7
8
9
10

测试通过...原理是把第1个表的数据classid取出来通过循环插入第2个表中..

_______________________________

回帖是种奉献!
给分是种回报!
欢迎光临:www.sodeer.com
_______________________________