游标里面嵌套游标

是游标里面嵌套游标吗？数据量大的话最好不要采用这种方法！

这是SQL SERVER的：

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

            DECLARE CUR_2 CURSOR          --第二层游标声明

            FOR SELECT A_1,A_2 FROM TABLENAME

            OPEN CUR_2

            FETCH NEXT FROM CUR_2 INTO @C_1,@C_2

            WHILE @@FETCH_STATUES<>0

             BEGIN

                      ..........

                    FETCH NEXT FROM CUR_2 INTO @A_1,@A_2--二层循环

             END

             CLOSE CUR_2

              DEALLOCATE CUR_2

FETCH NEXT FROM CUR_1 INTO @C_1,@C_2--一层循环

END

CLOSE CUR_1

DEALLOCATE CUR_1

http://zhidao.baidu.com/question/340233898.html