SQL游标格式

DECLARE @PI VARCHAR(150)

DECLARE @FNumber VARCHAR(150)

DECLARE @Privider VARCHAR(150)

DECLARE @FQTY float

DECLARE MyCursor CURSOR FOR –申明一个游标

select * from [Sheet3$] –where [物料长代码]=’1.03.03.0279′

OPEN MyCursor–打开一个游标

FETCH NEXT FROM  MyCursor INTO @PI,@FNumber,@Privider,@FQTY

WHILE @@FETCH_STATUS =0–循环一个游标

    BEGIN

   DECLARE @count float

       select @count=count(*) from T_PUR_POORDERENTRY where FMATERIALID in(select FMATERIALID

from T_BD_MATERIAL where fnumber=@FNumber) and F_VIVH_TEXT_PI=@PI

       if(@count<=1)

     begin

   print @FNumber+’   ‘+@PI+’   ‘+cast(@FQTY as varchar(50))

end

    FETCH NEXT FROM  MyCursor INTO @PI,@FNumber,@Privider,@FQTY

    END

–关闭游标

CLOSE MyCursor

–释放资源

DEALLOCATE MyCursor