Sqlserver游标复习详解数据库

Create  PROCEDURE [dbo].[temphxb] 
AS 
BEGIN 
    declare @uid int 
    declare mycursortemp Cursor 
        for select uid from temptable1 where Indate>'2015-05-21' and type='1' group by uid  having COUNT(*)>1 
    open mycursortemp 
    fetch next from mycursortemp into @uid 
         
    while @@FETCH_STATUS=0 
    begin 
        delete from temptable1 where id  
        in (select top 1 id from temptable1 where [email protected] and Indate>'2015-05-21' and fdtype='1') 
         
        update temptable2 set num=num+1 where uid=@uid 
        fetch next from mycursortemp into @uid 
    end 
 
    close mycursortemp 
    DEALLOCATE mycursortemp     
end