Q&A
| Q1: | I am trying to create a group of nested triggers, but they aren't working. What's wrong? |
| A1: | If you have coded your triggers properly and they still do not work, check whether the database option for allowing nested triggers is enabled. You can enable it with the following statement:
Exec sp_configure 'nested triggers', 1 |
| Q2: | What is the difference between a nested trigger and a recursive trigger? |
| A2: | A trigger is nested when it performs an action that would fire another trigger, which in turn would fire another trigger, and so on. A recursive trigger occurs when a trigger fires and performs an action that causes the same trigger to fire again. |
| Q3: | Why should derived columns be maintained within a trigger? |
| A3: | Most derived columns are ... |
Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
