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

转载于:https://www.cnblogs.com/isMe/archive/2005/11/07/270577.html