3.4w+
社区成员
SQL编程怎样遍历查询结果？
大概象这样吧
declare @num int
select number from table1 where number > 100
然后将查询结果循环赋值给 @num 变量
declare @num int
select number from table1 where number > 100
然后将查询结果循环赋值给 @num 变量
...全文
请发表友善的回复…
发表回复
Philip1314 2001-12-13
- 打赏
- 举报
多谢
王集鹄 2001-12-13
- 打赏
- 举报
DECLARE authors_cursor CURSOR
FOR SELECT * FROM authors
OPEN authors_cursor
FETCH NEXT FROM authors_cursor
FOR SELECT * FROM authors
OPEN authors_cursor
FETCH NEXT FROM authors_cursor
N_chow 2001-12-13
- 打赏
- 举报
動用Cursor.
Declare abc CURSOR FOR Select number from table1 where number>100
open abc
Fetch next from abc into @num
WHILE @@Fetch_status=0
begin
Print @num
Fetch next from abc into @num
end
close abc
deallocate abc
Declare abc CURSOR FOR Select number from table1 where number>100
open abc
Fetch next from abc into @num
WHILE @@Fetch_status=0
begin
Print @num
Fetch next from abc into @num
end
close abc
deallocate abc