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;