什么是游标和触发器之间的区别？用代码给出明确的例子.. [英] whats is the difference between cursors and triggers? give clear example with code..

问题描述

我试图找到游标和触发器之间的差异。

解决方案

游标 [ ^ ]与触发器 [ ^ ] - 它们是不同的结构，不能直接比较或对比。

游标允许逐行进行结果集。

触发器是一种特殊的存储过程，当在表上执行INSERT，UPDATE或DELETE操作时会自动执行。



更多信息：光标 [ ^ ] | 触发器 [ ^ ]

curser是一个数据库对象，并逐行从数据库中检索行。



触发它也是数据库对象，你可以执行动作触发器自动触发。

I trying to find the diff between cursors and triggers.

解决方案

Cursors [^]versus Triggers[^] - they are different constructs and cannot be compared or contrasted directly.

Cursors allow row-by-row prcessing of the resultsets.
Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place on a table.

More information: Cursor[^] | Trigger[^]

curser is an database object and retrive the rows from database row by row.

trigger it's also database object and you can perform an action trigger will fire automatacally.

这篇关于什么是游标和触发器之间的区别？用代码给出明确的例子..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！