On Update trigger, and using cursor
When you use On Update trigger, the update is probably for multiple rows开发者_如何学编程. MSDN said that using Cursors in triggers is bad thing for performance, what I should use then?
Thanks
If you want to update a column based in the rows updated, you can use a update statement joining the target table with the inserted virtual table. Of course, if your destination table is the same updated table, you must prevent recursive triggering, using instead of triggers, or updating the inserted table BEFORE the update happens.
Do you need code? Please be more specific about what exactly you need.
精彩评论