Steve Jones - SSC Editor (1/20/2011)
The NULL mistake is that people often write
where a.col = nullinstead of
where a.col is nullThe multi-row trigger is the same. Developers assume triggers fire once per row, instead of once per transaction. I have examples of why this is an issue.
So the common mistake is that some dim spark writes a single row trigger when a multiple row trigger is needed. That would make me list single row triggers as a common mistake, not multi-row triggers; do you really think it makes multi-row triggers a mistake?
Tom