关于fetch

[killxtt]

是不是在procedure里面写类似于eof和bof的判断的语句只能用fetch来决定，还有，procedure里面返回的值可以直接返回给asp程序里的参数么？

[zjcxc]

1.
是的,定义游标用fetch来循环读取.

例子:
create procedure aa
as
declare @a varchar(200)
declare #aa cursor for select name from sysobjects
open #aa
fetch next from #aa into @a
while @@fetch_status=0
begin
print @a
fetch next from #aa into @a
end
close #a
deallocate #a
go

[zjcxc]

2.要请ASP高手回答.

[killxtt]

呵呵，多谢，象你刚才写的哪个procedure可以嵌套吗？比如
create procedure aa
declare @b varchar（100）
as
declare @a varchar(200)
declare #aa cursor for select name from sysobjects
open #aa
fetch next from #aa into @a
while @@fetch_status=0
begin
print @a

aa '传送的参数'

fetch next from #aa into @a
end
close #a
deallocate #a
go

[Rivulet119]

可以嵌套。procedure里面返回的值可以直接返回给asp程序里的参数.

[pengdali]

--举个例吧，删除所有的用户表：

declare cursor1 cursor for select name from sysobjects where xtype='u'
declare @i varchar(1000)
open cursor1
fetch cursor1 into @i
while @@fetch_status=0
begin
exec('drop table '+@i) --这里
fetch cursor1 into @i
end
close cursor1
deallocate cursor1