SQL游标循环取值

declare @maxid int
declare @zhibanren nvarchar(30)
declare @shoujihao nvarchar(30)
declare @banci nvarchar(5)
declare @zhibanshijian datetime
select @maxid=ID from safe_message_zhibanbiao where day(getdate())=day(zhibanshijian)
if @maxid<>4
  begin
      declare Type_Cursor CURSOR FOR select zhibanren,shoujihao,banci,zhibanshijian from safe_message_zhibanbiao where day(getdate())=day(zhibanshijian)
      open Type_Cursor
      fetch next from Type_Cursor into @zhibanren,@shoujihao,@banci,@zhibanshijian
      while(@@fetch_status=0)
        begin         
          insert into safe_message_dangqianzhiban values (@zhibanren,@shoujihao,@banci,@zhibanshijian)
          fetch next from Type_Cursor into @zhibanren,@shoujihao,@banci,@zhibanshijian
        end     
      CLOSE   Type_Cursor  
      DEALLOCATE   Type_Cursor
end

转载于:https://www.cnblogs.com/windphoenix/archive/2009/09/03/1559814.html