--建立存储过程 create proc test @id varchar(20), @date datetime as set nocount onbegin delete from a where date between dateadd(day,-2,@date) and dateadd(day,2,@date) end begin insert into a(id,date) values(@id,@date) end go --执行存储过程 exec test 1,'2005-10-01'--测试 --select * from a
CREATE TRIGGER ON test FOR INSERT,UPDATE,DELETE AS IF EXISTS (SELECT * FROM INSERTED) BEGIN --删除记录 DELETE from yourtable .... end
create proc test
@id varchar(20),
@date datetime
as
set nocount onbegin
delete from a where date between dateadd(day,-2,@date) and dateadd(day,2,@date)
end
begin
insert into a(id,date) values(@id,@date)
end
go
--执行存储过程
exec test 1,'2005-10-01'--测试
--select * from a
FOR INSERT,UPDATE,DELETE
AS
IF EXISTS (SELECT * FROM INSERTED)
BEGIN
--删除记录
DELETE from yourtable ....
end