两个游标在嵌套的循环内怎样判断？

[xiaokun111]

判断用while(@@fetch_status = 0)这条语句

[victorycyz]

什么意思？能说清楚一点吗？

• 打赏
• 举报

回复 赞

[Rotaxe]

加一个临时变量，纪录第一个游标的fetch_status

• 打赏
• 举报

回复 赞

[wzh1215]

只要用法不错，就互不影响的！

• 打赏
• 举报

回复 赞

[zjcxc]

--一样,下面是例子:

declare t1 cursor for select top 2 name from sysobjects
declare t2 cursor for select top 2 name from syscolumns
open t1
declare @n1 sysname,@n2 sysname

fetch next from t1 into @n1
while @@fetch_status=0 --第一层循环
begin
print @n1
open t2
fetch next from t2 into @n2
while @@fetch_status=0 --第一层循环
begin
print ' '+@n2
fetch next from t2 into @n2
end
close t2
fetch next from t1 into @n1
end
close t1
deallocate t1
deallocate t2

/*--测试结果
sysobjects
name
id
sysindexes
name
id

--*/

• 打赏
• 举报

回复 赞