我候我自己已找到答案了
ALTER TRIGGER xxxxxxxx
ON dbo.MyTable
After UPDATE ,INSERT
AS
IF UPDATE (Audit)
Begin
declare @TriggerCount int
SELECT @TriggerCount= trigger_nestlevel( object_ID('要检测的触发器名称) ) if (@TriggerCount>=1)
return
else
to do something
end
ALTER TRIGGER xxxxxxxx
ON dbo.MyTable
After UPDATE ,INSERT
AS
IF UPDATE (Audit)
Begin
declare @TriggerCount int
SELECT @TriggerCount= trigger_nestlevel( object_ID('要检测的触发器名称) ) if (@TriggerCount>=1)
return
else
to do something
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货