CREATE OR ALTER TRIGGER trigger_table_1 ON table_1 FOR INSERT, UPDATE, DELETE AS DECLARE @Operation VARCHAR(15) IF EXISTS (SELECT 0 FROM inserted) BEGIN IF EXISTS (SELECT 0 FROM deleted) BEGIN SELECT @Operation = 'UPDATE' END ELSE BEGIN SELECT @Operation = 'INSERT' END END ELSE BEGIN SELECT @Operation = 'DELETE' END PRINT @Operation