How to: Create trigger for auto update modified date with SQL Server 2008

by

My approach:

  • define a default constraint on the ModDate column with a value of GETDATE() – this handles the INSERT case

  • have a AFTER UPDATE trigger to update the ModDate column

Something like:

CREATE TRIGGER trg_UpdateTimeEntry
ON dbo.TimeEntry
AFTER UPDATE
AS
    UPDATE dbo.TimeEntry
    SET ModDate = GETDATE()
    WHERE ID IN (SELECT DISTINCT ID FROM Inserted)

More Related Contents:

  1. Get first day of week in SQL Server
  2. error when inserting into table having instead of trigger from entity data framework
  3. If condition in SQL Server 2008
  4. Comma separated results in SQL
  5. Understanding PIVOT function in T-SQL
  6. Which are more performant, CTE or temporary tables?
  7. Using RegEx in SQL Server
  8. Import Excel spreadsheet columns into SQL Server database
  9. SqlServer: Login failed for user
  10. SQL Server 2008 Empty String vs. Space
  11. How do I use the CONCAT function in SQL Server 2008 R2?
  12. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  13. How do I exclude Weekend days in a SQL Server query?
  14. Is it possible to force row level locking in SQL Server?
  15. SQL Query to find the last day of the month
  16. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  17. How do I get date/time information from a TIMESTAMP column?
  18. How to drop column with constraint?
  19. SQL Server: combining multiple rows into one row
  20. How to add xml encoding to xml Output in SQL Server
  21. SQL Server GUID sort algorithm. Why?
  22. Comparing dates stored as varchar
  23. SQL Recursive CTE: Finding objects linked by property
  24. SQL “between” not inclusive
  25. Convert decimal time to hours and minutes
  26. Sort Bullets in Database
  27. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  28. How to wait for 2 seconds?
  29. How to find a text inside SQL Server procedures / triggers?
  30. Populate Dataset With Table Names From Stored Procedure

Leave a Comment