试下SQL2005 Common Table Expressions（CTE）递归
<div id="cnblogs_post_body"> 已经有很多朋友分享过了，自己亲身操作过，随便记录下来是给自己备忘，以后用到时不用乱找。http://pic002.cnblogs.com/images/2012/226988/2012121115215340.jpg
<div class="cnblogs_code">WITH cet_departAS( SELECT depart_id, depart_name FROM dbo.Depart WHERE depart_id = '004' --入口 UNION ALL --递归时必要 SELECT d.depart_id, d.depart_name FROMdepart d INNER JOIN cet_depart c ON CAST (c.depart_id AS INT) = d.upper_depart_id--递归条件)SELECT * FROM cet_departOPTION (MAXRECURSION 20) --最大递归次数
页:
[1]