本文章主要是针对数据库接收数据的情况,利用循环过程统计数据的传输率和最新上传的数据情况。
select * into #temptest from Data_DataDeskShow where 1 = 2
--FTIR/DOAS查询
declare @stationid int,@reporttime datetime,@belongdevices int
set @stationid = 1
set @reporttime = DATEADD(hour,12,'2018-06-07')
while @stationid < 9
begin
set @belongdevices = 0
while @belongdevices < 8
begin
insert into #temptest
select top 1 * from Data_DataDeskShow where stationID =