在Sql Server触发器中判断操作是Insert还是Update还是Delete
来源:百度文库 编辑:神马文学网 时间:2024/07/03 12:33:24
DECLARE
@IsInsert bit,
@IsUpdate bit,
@IsDelete bit
IF EXISTS(SELECT 1 FROM inserted) AND NOT EXISTS(SELECT 1 FROM deleted)
SET @IsInsert = 1
ELSE
SET @IsInsert = 0
IF EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)
SET @IsUpdate = 1
ELSE
SET @IsUpdate = 0
IF NOT EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)
SET @IsDelete = 1
ELSE
SET @IsDelete = 0
create trigger Update_Del on Table
for update,delete
as
if not exists(select 1 from inserted)
begin /*inserted表无记录,是删除*/
end
else
begin /*是更新*/ end
go
@IsInsert bit,
@IsUpdate bit,
@IsDelete bit
IF EXISTS(SELECT 1 FROM inserted) AND NOT EXISTS(SELECT 1 FROM deleted)
SET @IsInsert = 1
ELSE
SET @IsInsert = 0
IF EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)
SET @IsUpdate = 1
ELSE
SET @IsUpdate = 0
IF NOT EXISTS(SELECT 1 FROM inserted) AND EXISTS(SELECT 1 FROM deleted)
SET @IsDelete = 1
ELSE
SET @IsDelete = 0
create trigger Update_Del on Table
for update,delete
as
if not exists(select 1 from inserted)
begin /*inserted表无记录,是删除*/
end
else
begin /*是更新*/ end
go
在Sql Server触发器中判断操作是Insert还是Update还是Delete
数据库-选择MySQL还是SQL Server
SQL Server触发器在轨迹保留中的应用 Application of SQL Ser...
巧用SQL Server触发器保持数据完整性
SQL Server 2000中的触发器使用_1
Builder.com.cn-数据库-选择MySQL还是SQL Server
sql server 2005学习笔记之触发器简介(轉)
在SQL Server中计算ntext长度的函数
在SQL Server中谨慎导入导出大容量数据
sql 触发器
趋势-是上升还是下降的判断
怎么判断趋势是上升还是下降
SQL INSERT INTO 语句
SQL INSERT INTO 语句
如何根据成交量的变化,准确判断出主力是在出货还是洗盘呢
如何准确判断出主力是在出货还是洗盘
SQL DELETE 语句
如何判断主力在洗盘还是在出货
巧用SQL Server触发器保持数据完整性--维普资讯网
SQL INSERT INTO 语句1
SQL中判断是否存在..........
sql server 中易混淆的数据类型
SQL Server 中易混淆的数据类型
sql server 中易混淆的数据类型