游标可以嵌套。
游标嵌套
DECLARE CUR_1 CURSOR--第一层游标声明
FOR SELECT C_1,C_2 FROM TABLENAME
OPEN CUR_1
FETCH NEXT FROM CUR_1 INTO @C_1,@C_2
WHILE @@FETCH_STATUES<>0
BEGIN
DECLARECUR_2 CURSOR--第二层游标声明
FOR SELECTA_1,A_2 FROM TABLENAME
OPENCUR_2
FETCH NEXTFROM CUR_2 INTO @C_1,@C_2
WHILE@@FETCH_STATUES<>0
BEGIN
.....
.....
FETCH NEXTFROM CUR_2 INTO @A_1,@A_2--二层循环
END
CLOSECUR_2
DEALLOCATECUR_2
FETCH NEXT FROM CUR_1 INTO@C_1,@C_2--一层循环
END
CLOSE CUR_1
DEALLOCATE CUR_1
http://blog.sina.com.cn/s/blog_604fb7ae01012jhn.html
游标嵌套
DECLARE CUR_1 CURSOR--第一层游标声明
FOR SELECT C_1,C_2 FROM TABLENAME
OPEN CUR_1
FETCH NEXT FROM CUR_1 INTO @C_1,@C_2
WHILE @@FETCH_STATUES<>0
BEGIN
FETCH NEXT FROM CUR_1 INTO@C_1,@C_2--一层循环
END
CLOSE CUR_1
DEALLOCATE CUR_1
http://blog.sina.com.cn/s/blog_604fb7ae01012jhn.html