Determine whether the operation is insert, update, or delete in the SQL Server trigger.

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/* The inserted Table has no record and is deleted */
End
Else
Begin/* update */end
Go