SQL 游标使用——备忘

 
SET NOCOUNT ON

DECLARE @net_in bigint, @net_out bigint, @logdate datetime, @id int

declare doc_cursor cursor for
select net3_in,net3_out, logdate
from glbk.gltraffic.dbo.snmp_net_v
where serid=94 and logdate < '2007-03-01 18:20:00' --and logdate > '2007-03-01 17:20:00'
order by logdate

open doc_cursor

FETCH NEXT FROM doc_cursor
into @net_in, @net_out, @logdate

while @@FETCH_STATUS = 0
begin
 print @net_out
 --print @logdate
 update snmp_net_v set net4_in=@net_in, net4_out=@net_out
 where logdate = @logdate and serid=94
    FETCH NEXT FROM doc_cursor
 into @net_in, @net_out, @logdate
END

CLOSE doc_cursor
DEALLOCATE doc_cursor
GO