1. 树(sql2005以上版本)
--通过子节点查询父节点 WITH TREE AS( SELECT * FROM tstructure WHERE id = 6 -- 要查询的子 id UNION ALL SELECT tstructure.* FROM tstructure, TREE WHERE TREE.parent = tstructure.id ) SELECT * FROM TREE --通过父节点查询子节点 WITH TREE AS ( SELECT t.*, 0 level FROM t_sys_menu t WHERE t.menu_id = 1 -- 要查询的父 id UNION ALL SELECT m.*, Tree.level + 1 FROM t_sys_menu m, TREE WHERE m.up_menu_id = TREE.menu_id ) SELECT * FROM TREE --通过子节点查询父节点 WITH TREE AS( SELEC
阅读背景：
MS-SQL数据库笔记
来源：互联网
分享到：
