摘要： -- SQL2005 递归查询示例，非常方便 -- Author:BOBBY WITH tree AS (SELECT F_DEPT_ID, CAST(F_DEPT_NAME AS varchar(MAX)) AS F_DEPT_NAME FROM dbo.T_ACCOUNTS_DEPT_INFO AS A WHERE (F_PARENT_DEPT... 阅读全文