游标架构

ALTER proc [dbo].[CT_PROC] as declare @MP_ID int declare @coef varchar(32) declare CT_MAP_PROC cursor for select jldid from KDPARADB.DBO.meter_map open CT_MAP_PROC delete from MAP_CT fetch next from CT_MAP_PROC into @MP_ID while(@@FETCH_STATUS = 0) begin select top (1) @coef = coef from KDJC_TMSDB..TMRDBOWNER.CT where MP_ID=@MP_ID order by OPER_TIME DESC insert into MAP_CT values(@MP_ID,@coef) fetch next from CT_MAP_PROC into @MP_ID end close CT_MAP_PROC deallocate CT_MAP_PROC