开发者

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.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜