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...
Sqlserver Trigger(Insert,Update,Delete)
最新推荐文章于 2023-05-23 11:01:03 发布