判断数据库表dml操作的类型

最新推荐文章于 2025-08-13 17:42:51 发布

原创最新推荐文章于 2025-08-13 17:42:51 发布 · 330 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #testing #action #insert #delete #table

t_sql_程序设计_dmltrigger 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了一种使用SQL触发器来判断数据库中插入、更新和删除等DML操作的方法，并通过创建测试表和触发器来演示这些操作的具体实现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

判断数据库dml操作的类型
--演示准备
if object_id(N'testing','U') is not null
drop table testing
go
create table testing
(id smallint
)
go
if object_id(N'tr_dml_type_testing','TR') is not null
drop trigger tr_dml_type_testing
go
create trigger tr_dml_type_testing on testing
for insert,delete,update
as
if exists (select 1 from inserted) and not exists(select 1 from deleted)
print 'the action is insert'
if exists (select 1 from inserted) and exists(select 1 from deleted)
print 'the action is update'
if not exists (select 1 from inserted) and exists(select 1 from deleted)
print 'the action is delete'
--测试
insert into testing select 1

/*
the action is insert

(1 行受影响)
*/
update testing set id=2
/*
the action is update

(1 行受影响)
*/

delete from testing
/*
the action is delete

(1 行受影响)
*/

--删除测试
drop table testing