SQL的特定记录中触发了多少个触发事件 [英] How many Trigger Event fire in a particular record in SQL

问题描述

大家好，
我必须找出在SQL数据库的特定记录中触发了多少Trigger事件，可以通过SQL命令帮助我，通过它我可以找到结果.

感谢ALL

Hi all,
I have to find out that how many Trigger event fire in a particular record in SQL data base, can any help me by SQL command through which I can find out the result.

Thanks to ALL

推荐答案

感谢您的提问.

1. sp_helptrigger
2. sys.triggers
3. sys.trigger_events

以上是SQL函数将帮助您解决问题.

让我们尝试一下.

谢谢，
马蒙

Thank you for your question.

1. sp_helptrigger
2. sys.triggers
3. sys.trigger_events

Above are the SQL function will help you out from the problem.

Lets try with it.

Thanks,
Mamun

这篇关于SQL的特定记录中触发了多少个触发事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！