Trigger to fire only if a condition is met in SQL Server

by

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

More Related Contents:

  1. Insert Update trigger how to determine if insert or update
  2. Creating audit triggers in SQL Server
  3. How to: Create trigger for auto update modified date with SQL Server 2008
  4. error when inserting into table having instead of trigger from entity data framework
  5. SQL Server history table – populate through SP or Trigger?
  6. SQL Server ON DELETE Trigger
  7. How to find a text inside SQL Server procedures / triggers?
  8. How to get the last row from a table in SQL Server?
  9. Storing a file in a database as opposed to the file system?
  10. SQL Server named instance with Visual Studio 2017 Installer project
  11. How do you count the number of occurrences of a certain substring in a SQL varchar?
  12. Why is it considered bad practice to use cursors in SQL Server?
  13. Import Excel spreadsheet columns into SQL Server database
  14. Find index of last occurrence of a sub-string using T-SQL
  15. Hidden Features of SQL Server
  16. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  17. SQL Server 2008 Empty String vs. Space
  18. How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
  19. SQL Query to find the last day of the month
  20. SQL Server, convert a named instance to default instance?
  21. How to drop column with constraint?
  22. How do I search an SQL Server database for a string?
  23. WHERE clause on SQL Server “Text” data type
  24. Does the order of columns in a WHERE clause matter?
  25. What is the best way to implement Polymorphic Association in SQL Server?
  26. Set option 9 in SQL Server stored procedure using WinHttp.WinHttpRequest.5.1 for TLS 1.2
  27. Taking the second last row with only one select in SQL Server?
  28. What is the difference between Cartesian product and cross join?
  29. How to Bulk Insert from XLSX file extension?
  30. Count number of records returned by group by

Leave a Comment