Sql Server 数据库游标的使用

       DECLARE @LS_COVGCODE  CHAR(3)

              DECLARE @LS_EFFDATE DATETIME

 

              DECLARE cur_dep_ben CURSOR FOR

              SELECT CHGEFFDATE,COVGCODE FROM TDEPENDENT

               WHERE  (PRODTYPE ='M' OR PRODTYPE ='L' OR PRODTYPE ='P')

               

              OPEN cur_dep_ben

              FETCH cur_dep_ben INTO @LS_EFFDATE,@LS_COVGCODE

              WHILE @@fetch_status = 0

              BEGIN

                     select * from a_temp

                    

                FETCH cur_dep_ben INTO @LS_EFFDATE,@LS_COVGCODE

              END

             

              CLOSE cur_dep_ben;

              DEALLOCATE cur_dep_ben;