416

Name


	곽진석

Subject

커서 예제

set nocount on
declare @FirstDate varchar(20)
declare @LastDate varchar(20)
DECLARE curNonProd3Ratio Cursor
FOR
        select Manufacture,Managementindustry from #Temp
        OPEN curNonProd3Ratio
        FETCH Next From curNonProd3Ratio into  @FirstDate, @LastDate
        WHILE @@FETCH_STATUS =0
        Begin

         select           @FirstDate, @LastDate

         FETCH Next From curNonProd3Ratio into  @FirstDate, @LastDate
        End
CLOSE curNonProd3Ratio
DEALLOCATE curNonProd3Ratio

Prev	링크 서버 예제	곽진석

Do While 문 관련

곽진석