Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update date to a current date in the event of value chan
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01469101
Message ID:
01469367
Views:
30
Sorry to steal your instructor time for free, but out of curiosity... Would have it mattered if recursive was turned on? I would think that as the second call to the trigger there would be no records complying with WHERE Inserted.nStndCost # Deleted.nStndCost as the only field updated within the trigger was dStndCost, thus ending the trigger and the recursion with some overhead.

Hi, Hugo, good question. To be honest, aside from any impact of additional overhead, I don't know of any additional harm in this instance. (Though since they're disabled by default, one would only use them for specific reasons). Maybe someone else reading this can jump in.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform