SQL Server触发器判断当前操作类型(insert/update/delete)示例

create trigger updateRowVersion on PPM_JobBill
after insert,update,delete
as
begin
	declare @inserted int, @deleted int
	select @inserted=COUNT(*) from inserted
	select @deleted=COUNT(*) from deleted
	if @inserted>0 and @deleted=0
	begin
		--insert
	end
	else if @inserted>0 and @deleted>0
	begin
		--update
	end
	else if @inserted=0 and @deleted>0
	begin
		--delete
	end
end
go