sql游标实例

declare mycur cursor for select distinct doccode from SAF_Approv where FormId = 75105
open mycur 
declare @doccode varchar(20)
fetch next from mycur into @doccode

 while @@FETCH_STATUS=0
  begin 
   select @doccode
   --update SAF_Approv set title = FLOOR(rand()*3) where doccode =@doccode
   fetch next from mycur into @doccode
   end
   close mycur
 DEALLOCATE mycur