Sqlserver Trigger(Insert,Update,Delete)

最新推荐文章于 2023-05-23 11:01:03 发布

wateryi

最新推荐文章于 2023-05-23 11:01:03 发布

阅读量561

点赞数

本文链接：https://blog.csdn.net/liwateryi/article/details/53940706

版权

create trigger Tr_UpdateOrInertOrDelete on TEST_INFO 
for update,insert,delete 
as 
IF EXISTS (SELECT 1 FROM INSERTED ) AND NOT EXISTS (SELECT 1 FROM DELETED)--插入
BEGIN
	print 'insert'
END
ELSE  IF EXISTS (SELECT 1 FROM INSERTED ) AND EXISTS (SELECT 1 FROM DELETED)--更新
BEGIN
	print 'update'
END
ELSE  IF NOT EXISTS (SELECT 1 FROM INSERTED ) AND EXISTS (SELECT 1 FROM DELETED)--删除
BEGIN
	print 'delete'
END
--todo...