mssql游标的简单应用

--游标修改数据declare alarm_cursor cursor global SCROLL forselect lsc_id,station_id,alarm_time,clear_time,start_time,end_time from #tmpTelemetertwoday  open alarm_cursor --声明变量declare @lsc_id intdeclare @station_id intdeclare @alarm_time datetime declare @clear_time datetime declare @start_time datetime declare @end_time datetime --取下一条数据源 fetch next from alarm_cursor into @lsc_id,@station_id,@alarm_time,@clear_time,@start_time,@end_time----循环@@Fetch_STATUS=0while @@Fetch_STATUS=0begin--停电开始时间早于查询时间,全部等于查询开始时间  if(@alarm_time<@ts )   begin   set @alarm_time=@ts    end--停电结束时间晚查询时间,全部等于查询结束时间  if(@clear_time>@te )   begin   set @clear_time=@te   end--油机开始时间早于查询时间,全部等于查询开始时间  if(@start_time<@ts )   begin   set @start_time=@ts    end--油机结束时间晚查询时间,全部等于查询结束时间  if(@end_time>@te )   begin   set @end_time=@te   end   --把符合条件的数据插入到另一张临时表insert into #tmpTelemetertwodaytwo   (lsc_id,station_id,alarm_time,clear_time,start_time,end_time) values(@lsc_id,@station_id,@alarm_time,@clear_time,@start_time,@end_time )--取下一条数据源fetch next from alarm_cursor into @lsc_id,@station_id,@alarm_time,@clear_time,@start_time,@end_timeend--关闭游标close alarm_cursordeallocate alarm_cursor