If Your Trigger Uses UPDATE(), It's Probably Broken.
In yesterday’s blog post about using triggers to replace computed columns, a lively debate ensued in the comments. A reader posted a trigger that I should use, and I pointed out that their trigger had a bug – and then lots of users repli...
Saved by: Huy Vũ