Craete trigger tg_insert_update_delete on
people FOR INSERT,UPDATE,DELETE
As
begin
if (select count(*) from inserted)>0
begin
if (select count(*) from deleted)>0 --update
begin
print 'Update'
end
else
begin
print 'insert' --insert
end
end
else if (select count(*) from deleted)>0 -- only delete
begin
print 'delete'
end
end
--Now Execute
Insert into People values(1)
Update people set a=190 where a=2
Delete from people where a=190