什么是游标和触发器之间的区别?用代码给出明确的例子.. [英] 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屋!
查看全文