Re: Trigger to fire when condition met

[Elvento Labs]

Given that a WHERE clause did not work, maybe this will:

CREATE TRIGGER
[dbo].[SystemParameterInsertUpdate]
ON
[dbo].[SystemParameter]
FOR INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON

If (SELECT Attribute FROM INSERTED) LIKE 'NoHist_%'
Begin
Return
End

INSERT INTO SystemParameterHistory
(
Attribute,
ParameterValue,
ParameterDescription,
ChangeDate
)
SELECT
Attribute,
ParameterValue,
ParameterDescription,
ChangeDate
FROM Inserted AS I
END