SQL语句实现递归

        

1 WITH TempDeptment ([ID],[PID],[DeptName],[Conjunction]) AS
2 (
3     SELECT [ID],[PID],[DeptName], CAST([DeptName] AS Nvarchar(1000)) FROM [dbo].[Deptment] WHERE [PID] = 0
4     UNION ALL
5     SELECT d.[ID], d.[PID], d.[DeptName], CAST(([Conjunction] + N'/' + d.[DeptName]) AS Nvarchar(1000))    FROM TempDeptment AS td,[dbo].[Deptment] AS d WHERE td.[ID] = d.[PID]
6 )
7 SELECT [ID], [Conjunction] FROM TempDeptment

转载于:https://www.cnblogs.com/it-bobo/p/3860761.html