sql server 树形表的一些操作

--通过子节点查询父节点WITH TREE AS(     SELECT * FROM tstructure     WHERE id = '要查询的子 id'     UNION ALL     SELECT tstructure.* FROM tstructure, TREE     WHERE TREE.parent = tstructure.id) SELECT * FROM TREE--通过父节点查询子节点WITH TREE AS(     SELECT * FROM tstructure     WHERE parent = '要查询的父 id'    UNION ALL     SELECT tstructure.* FROM tstructure, TREE     WHERE tstructure.parent = TREE.id) SELECT * FROM TREE