SQL Server中的遊標使用

declare @chrname varchar(30)
declare @chryhm varchar(30)

DECLARE dw_only1 cursor for   --設定游標取出記錄集進行操作
   select chrname,chryhm from gzry where chrzw>=5 Order By chrzw desc,intpxh  --職務是正處及以上的選出來
   open dw_only1
   while(1>0)
   begin
      fetch dw_only1 into  @chrname,@chryhm
      if(@@fetch_status=-1)
        begin
          close dw_only1   
          deallocate  dw_only1     
          break
        end
      if(@@fetch_status=-2)
      begin
          close dw_only1   
          deallocate dw_only1
          break
      end
     ---select  @chrname,@chryhm
        --對相應的人進行付許可權
       delete from yhmkqx where chryhm=@chryhm and chrmkbm like '004005%'
       insert into yhmkqx(chryhm,chrmkbm) values(@chryhm,'004005')

   end --------end while