触发器(九)Trigger_Insert_PollMin_deleteData

来源：互联网发布：仪表总里程算法编辑：程序博客网时间：2024/05/21 23:53

USE [AirDB_YiZhuang]
GO

/****** Object: Trigger [dbo].[Trigger_Insert_PollMin_deleteData] Script Date: 2017/12/25 17:09:20 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author: pyy
-- Create date: 2017-02-16
-- Description: [dbo].[T_Data_PollMin]表中插入数据时，删除一个月前的历史数据
-- =============================================
CREATE TRIGGER [dbo].[Trigger_Insert_PollMin_deleteData]--创建的触发器名称
ON [dbo].[T_Data_PollMin] --触发器基于的表
AFTER INSERT --触发类型:插入时触发
AS
BEGIN
declare @Mint datetime
--最小时间
set @Mint=(select min(MONIDATE) from [AirDB_YiZhuang].[dbo].[T_Data_PollMin])

if(@Mint< =DATEADD(MONTH,-1,GETDATE()))
delete from [AirDB_YiZhuang].[dbo].[T_Data_PollMin] where MONIDATE<=DATEADD(MONTH,-1,GETDATE())

END

GO

阅读全文

'); })();