Insert Update trigger how to determine if insert or update

by

Triggers have special INSERTED and DELETED tables to track “before” and “after” data. So you can use something like IF EXISTS (SELECT * FROM DELETED) to detect an update. You only have rows in DELETED on update, but there are always rows in INSERTED.

Look for “inserted” in CREATE TRIGGER.

Edit, 23 Nov 2011

After comment, this answer is only for INSERTED and UPDATED triggers.
Obviously, DELETE triggers can not have “always rows in INSERTED” as I said above

More Related Contents:

  1. Check if table exists in SQL Server
  2. How do I create a unique constraint that also allows nulls?
  3. How do I get list of all tables in a database using TSQL?
  4. Get first day of week in SQL Server
  5. What is the significance of 1/1/1753 in SQL Server?
  6. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  7. Escape a string in SQL Server so that it is safe to use in LIKE expression
  8. Confused about UPDLOCK, HOLDLOCK
  9. Creating audit triggers in SQL Server
  10. TSQL Email Validation (without regex)
  11. Dynamic SQL results into temp table in SQL Stored procedure
  12. Need to list all triggers in SQL Server database with table name and table’s schema
  13. SQL Server Output Clause into a scalar variable
  14. Sequence as default value for a column
  15. TABLOCK vs TABLOCKX
  16. How to convert number of minutes to hh:mm format in TSQL?
  17. How do I select last 5 rows in a table without sorting?
  18. SELECT INTO a table variable in T-SQL
  19. T-SQL query to show table definition?
  20. How can I insert binary file data into a binary SQL field using a simple insert statement?
  21. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  22. Include missing months in Group By query
  23. comma delimited list as a single string, T-SQL [duplicate]
  24. SQL Server error “Implicit conversion of because the collation of the value is unresolved due to a collation conflict.”
  25. SQL SERVER – Understanding how MIN(text) works
  26. Pivot multiple columns based on one column in SQL Server
  27. @@ERROR and/or TRY – CATCH
  28. INSERT INTO @TABLE EXEC @query with SQL Server 2000
  29. How to calculate difference in hours (decimal) between two dates in SQL Server?
  30. Cannot delete rows from a temporal history table

Leave a Comment