Category: SQL

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