How do I prevent a database trigger from recursing?

by

Not sure if it is pertinent to the OP’s question anymore, but in case you came here to find out how to prevent recursion or mutual recursion from happening in a trigger, you can test for this like so:

IF TRIGGER_NESTLEVEL() <= 1/*this update is not coming from some other trigger*/

MSDN link

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. T-SQL split string
  3. Unpivot with column name
  4. How can I get column names from a table in SQL Server?
  5. Conditional WHERE clause in SQL Server
  6. How can I select the first day of a month in SQL?
  7. Is the NOLOCK (Sql Server hint) bad practice?
  8. Multi-statement Table Valued Function vs Inline Table Valued Function
  9. Convert varchar into datetime in SQL Server
  10. Select statement to find duplicates on certain fields
  11. Check if a row exists, otherwise insert
  12. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  13. Parse comma-separated string to make IN List of strings in the Where clause
  14. Compare DATETIME and DATE ignoring time portion
  15. Need to list all triggers in SQL Server database with table name and table’s schema
  16. Split function in SQL Server 2008
  17. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  18. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  19. TransactSQL to run another TransactSQL script
  20. Store multiple bit values in a single table column
  21. Which SQL query is faster? Filter on Join criteria or Where clause?
  22. SQL Server equivalent to MySQL enum data type?
  23. How can I group by date time column without taking time into consideration
  24. Using IF ELSE statement based on Count to execute different Insert statements
  25. How to combine results of two queries into a single dataset
  26. When using GETDATE() in many places, is it better to use a variable?
  27. SQL Server SELECT INTO @variable?
  28. COALESCE Function in TSQL
  29. Using CASE Statement inside IN Clause
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment