SQL table trigger template

Simple and easy to use trigger template:

Create Trigger [dbo].[Trigger_IU]
on [dbo].[TableName]
after INSERT, UPDATE, DELETE
as
begin
Set nocount on;

declare @activity char;
set @activity = ”;

declare @i int, @d int;

select @i = count(*) from inserted;
select @d = count(*) from deleted;

if @i > 0 and @d = 0 begin set @activity = ‘i’ end; —- Insert
if @i = 0 and @d > 0 begin set @activity = ‘d’ end; —- Delete
if @i > 0 and @d > 0 begin set @activity = ‘u’ end; —- Update

print @activity;
—- Insert or Update
if @activity = ‘i’ or @activity = ‘u’ begin
    if update(ColumnName) begin
        Print ‘ColumnName updated’;
    end;

—- Delete
end else if @activity = 'd' begin
    Print 'Deleting…';
end;

end;