How Can I Prevent Recursive Triggers in SQL Server 2008?

Preventing Recursive Triggers in SQL Server 2008

To address the issue of a recursive trigger, let's examine the trigger provided:

ALTER TRIGGER [dbo].[tblMediaAfterInsertOrUpdate] 
   ON  [dbo].[tblMedia]
   BEFORE INSERT, UPDATE
AS 
BEGIN
    SET NOCOUNT ON

    DECLARE @IdMedia INTEGER,
        @NewSubject NVARCHAR(200)   

The above is the detailed content of How Can I Prevent Recursive Triggers in SQL Server 2008?. For more information, please follow other related articles on the PHP Chinese website!