ConditionBlockParentCondition_DAG_Check
Definition
Copy
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