游标使用方法

declare sp  cursor    for         --声明游标select * from table1               --游标后面跟的sql语句

declare  @COMCODE int ,@RPT_SRC intdeclare  @RPT_DATE datetime, @ENDDATE  datetime

open sp  --打开游标fetch next from sp into @COMCODE,@RPT_DATE,@ENDDATE,@RPT_SRC ----提取数据while @@fetch_status=0   --- --判断是否成功获取数据begininsert into CGENIUS..STK_FIN_IDXexec  C_STK_FIN_IDX_MAIN @COMCODE,@RPT_DATE,@ENDDATE,@RPT_SRCfetch next from sp into @COMCODE,@RPT_DATE,@ENDDATE,@RPT_SRC ----提取数据ENDclose sp--关闭游标。deallocate sp    ---释放游标

http://zhidao.baidu.com/link?url=CUDy55FF7Tx0huQw2Vu7DUtwS-6tDjyqlxnmGUxn4PL6bD_RPN_FK8QMMXxvOEpPqS90KRs8-xuO8tPiAXo5lK

http://www.cnblogs.com/xugang/archive/2012/10/22/2734218.html