Sql Server常用命令整理篇：查询数据补全缺测日期序列

数据存储可能存在缺测中断日期，然后通过left join进行关联

select * from (

select dateadd(HOUR,number,'2020-02-1 00:00') as dt
 from master.dbo.spt_values  where type ='P'
and number <=DATEDIFF(HOUR, '2020-02-1 00:00', '2020-02-01 23:00')

) a
left join (

select station_num 站号,observe_date 日期,o3_1h_value 浓度 from envi_observe_hour_data  where station_num='57131' and observe_date>='2020-02-01' and observe_date<='2020-02-01' 

) b 

on a.dt=b.日期