October 24, 2013 at 10:15 pm
Hi,
my version is as follow:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
(No column name)(No column name)(No column name)
11.0.2100.60RTMExpress Edition (64-bit)
Select @@version
(No column name)
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
FROM http://technet.microsoft.com/en-us/library/ms189799.aspx
Indirect recursion
With indirect recursion, an application updates table T1. This fires trigger TR1, updating table T2. In this scenario, trigger T2 then fires and updates table T1.
Direct recursion
With direct recursion, the application updates table T1. This fires trigger TR1, updating table T1. Because table T1 was updated, trigger TR1 fires again, and so on.
http://technet.microsoft.com/en-us/library/ms190739.aspx
Direct recursion
This recursion occurs when a trigger fires and performs an action that causes the same trigger to fire again. For example, an application updates table T3; this causes trigger Trig3 to fire. Trig3 updates table T3 again; this causes trigger Trig3 to fire again.
Direct recursion can also occur when the same trigger is called again, but after a trigger of a different type (AFTER or INSTEAD OF) is called.
Indirect recursion
This recursion occurs when a trigger fires and performs an action that causes another trigger of the same type (AFTER or INSTEAD OF) to fire.
seems to me that both facts in http://technet.microsoft.com/en-us/library/ms190739.aspx are actually the same, i.e. they all gone through different tables, i.e indirect recursion. Is direct or indirect something to do with the intermediate tables or type of triggers in the intermediate stage.
how do you classified the type of recursive trigger as stated in http://technet.microsoft.com/en-us/library/ms190739.aspx
how do we know if a recursive trigger is direct or indirect?
thanks
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy