dwain.c (5/10/2012)
Sean Lange (5/10/2012)
There was a story in another thread a few months ago by one of the regulars about a company that went belly up because their triggers couldn't handle multiple rows.
Sean - I would really like to read that article if you could find it.
We have an application that we support here and it ran up against just this issue. I hit upon the fact that ALL triggers should be able to support multiple rows (I call them bulk triggers) and not just single rows as a common sense thing without even the need to seek advice. Ultimately I went back through that app and rewrote every single bloody trigger in the thing to handle bulk ops.
The article would be useful to me to impress this point upon others not as enlightened.
For some I am thinking it was Brandie. I will ping the thread and see if anybody wants to come forward. It wasn't a story that had much more detail than what I posted but we will see what turns up. 😛