如何检查在C＃中触发的sql触发器？ [英] how to check sql trigger fired in C#?

问题描述

你好，我希望你没关系我需要一些关于如何在C＃中检查触发器是否被触发的帮助。

Hello,All i hope you are fine i need some help regarding how to check trigger is fired or not in C#.

推荐答案

我不认为它可能。触发器在更新，插入或删除期间自动启动。但是，您可以验证触发器的可用性状态，如下所示：

I don't think its possible. Triggers automatically initiate during update, insert or delete. But, you can validate the availability status of trigger as below:

select * from dbo.sysobjects
where name = 'MyTrigger' and OBJECTPROPERTY(id, 'IsTrigger')

这篇关于如何检查在C＃中触发的sql触发器？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！