3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
...全文
请发表友善的回复…
发表回复
zjcxc--个人微信公共号同名 2003-12-22
--一样,下面是例子:
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
--*/
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
--*/
wzh1215 2003-12-22
只要用法不错，就互不影响的！
Rotaxe 2003-12-22
加一个临时变量，纪录第一个游标的fetch_status
victorycyz 2003-12-22
什么意思？能说清楚一点吗？