Posted on 2009-04-26
I was reading about DML triggers. One of the common issue we face while dealing with triggers is modification for multiple rows. As triggers are set based, we need to handle all the rows at once.
One of the solution is to use Cursors, which is not recommended due to performance constraints.
Another solution, I found in "Unleashed (SQL Server 2005)" is "Rowset-based logic". It doesn't say more about it. I was wondering if anyone have used or knows how this solution works.
Also, if there is any other solution you know, please let me know.