sqlserver 通过触发器 自动生成报表 数据表 每小时自动生成报表

 这段时间做一个项目，想着不改程序的情况下，实现库里一些报表的自动创建功能。

就有了以下思路

Create TRIGGER  TRIGGER_AUTOCREATEREPORT
  on [sensor]
  after update
as
	begin
		truncate table test1_report
		insert into  test1_report
		select MAX(CO2)  max_CO2,MAX(CH4)  max_CH4, MAX(temperature)  max_temperature, MAX(humidity)  max_humidity, 
		datepart(hh,uploadTime) [Hour]
		from sensorData
		where uploadTime between --'2020-07-15 00:00:00' and '2020-07-15 23:59:59'
		(select CAST(CAST(GETDATE() as date) as varchar(10)) + ' 00:00:00')
		and
		(select CAST(CAST(GETDATE() as date) as varchar(10)) + ' 23:59:59')
		group by datepart(hh,uploadTime)
	end
go

解释下：

TRIGGER_AUTOCREATEREPORT   触发器的名字

test1_report  存报表的数据表名字