开发者

On Update trigger, and using cursor

开发者 https://www.devze.com 2023-02-01 01:14 出处:网络
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?

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消