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 calculations that require more information than is available in the column. You will probably want to get information from other tables, or update a calculated column in a second table when the first one is modified. |
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.