set nocount on
go
if object_id('tr_tbl') is not null
drop table tr_tbl
go
create table tr_tbl(i int)
go
create trigger tr_test on tr_tbl for insert, update, delete as
if exists(select * from inserted) and exists(select * from deleted)
print 'Update...'
else
if exists(select * from inserted)
print 'Insert...'
else
print 'Delete...'
go
insert tr_tbl values(1)
update tr_tbl set i = i + 1
delete tr_tbl