触发问题...非常有趣 [英] Trigger issue...very interesting

问题描述

我有一个触发器:

I have a trigger :

 create trigger tt
   on Mytable
   AFTER INSERT 
  AS
   BEGIN
   INSERT INTO Mytable(id) values(10)
END

问题:这应该无限期触发，但事实并非如此.为什么?

QUESTION : This should fire indefinately, but it doesn''t. Why ?

推荐答案

这是设计使然.您可以在此处找到相关信息 [

This is by design. You can find information about it here[^]

与sp_dboption和sp_configure有关.单击链接并搜索递归触发器设置".差不多可以解释了.

http://msdn.microsoft.com/en-us/library/aa258254 (v = sql.80).aspx


祝你好运，

曼弗雷德(Manfred)

It has to do with sp_dboption and sp_configure. Follow the link and search for "recursive triggers setting". That pretty much explains it.

http://msdn.microsoft.com/en-us/library/aa258254(v=sql.80).aspx


Good luck,

Manfred

这篇关于触发问题...非常有趣的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！