CREATE TRIGGER tr1 ON table FOR INSERT AS DECLARE @ddate date select @ddate = CONVERT(date,时间字段,112) from inserted delele * from table where 时间字段 = dateadd(dd,30,时间字段) GO
CREATE TRIGGER tr1 ON table FOR INSERT AS DECLARE @ddate date select @ddate = CONVERT(date,时间字段,112) from inserted delele * from table where 时间字段 = dateadd(dd,30,时间字段) GO
FOR INSERT AS
DECLARE @ddate date
select @ddate = CONVERT(date,时间字段,112) from inserted
delele * from table where 时间字段 = dateadd(dd,30,时间字段)
GO
FOR INSERT AS
DECLARE @ddate date
select @ddate = CONVERT(date,时间字段,112) from inserted
delele * from table where 时间字段 = dateadd(dd,30,时间字段)
GO