简单触发器，用作定时程序时用

最新推荐文章于 2024-05-28 09:50:09 发布

liuliqin132

最新推荐文章于 2024-05-28 09:50:09 发布

阅读量518

点赞数

分类专栏： SQL 文章标签： insert date go delete

本文链接：https://blog.csdn.net/liuliqin132/article/details/1740599

版权

SQL 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

create TRIGGER t_i
ON CrawContent
FOR insert
as
insert CrawContent_tigger(id,companyName,introduce,homepage,mdate,[type],inputdate,state,updatetime,times,tig_type,tig_date)
select *,'i',getdate() from Inserted
go

create TRIGGER t_u
ON CrawContent
FOR update
as
insert CrawContent_tigger(id,companyName,introduce,homepage,mdate,[type],inputdate,state,updatetime,times,tig_type,tig_date)
select *,'u',getdate() from Inserted
go

create TRIGGER t_d
ON CrawContent
FOR delete
as
insert CrawContent_tigger(id,companyName,introduce,homepage,mdate,[type],inputdate,state,updatetime,times,tig_type,tig_date)
select *,'d',getdate() from Deleted
go