触发以防止sql树中的无限循环

I have node table with (NodeId, NodeName) and structure table (ParentNodeId, ChildNodeId). How can I write a trigger that check if an insert update or delete statement can cause infinite relation?I have node table with (NodeId, NodeName) and s