![]() |
---|
CREATE TRIGGER [dbo].[ConditionBlockParentCondition_DAG_Check] ON [dbo].[ConditionBlockParentCondition] FOR INSERT, UPDATE AS DECLARE @n int SELECT @n = Sum([dbo].[fnWillCreateCyclicConditionalContent](i.ConditionBlockID, i.ParentConditionID)) FROM inserted i IF @n > 0 BEGIN RAISERROR ('Attempt to create cyclic graph detected.', 15, 1) ROLLBACK END |