MS SQL Server recursive query

Just in the forum to see the Netizen a request. Refer to the following, insus.net analysis, you can use the MS SQL Server recursive query to get results.




Prepare a table:

Populate this table with the data provided by the user:



The following syntax works correctly under SQL Server 2014:


In the above code example, the full SQL code:

 withTempdeptment ([ID],[PID],[Deptname],[conjunction]) as(    SELECT [ID],[PID],[Deptname],CAST([Deptname]  as Nvarchar( +)) from [dbo].[deptment] WHERE [PID] = 0    UNION  All    SELECTD.[ID]D.[PID]D.[Deptname],CAST(([conjunction] +N'/' +D.[Deptname]) as Nvarchar( +)) fromTempdeptment asTd[dbo].[deptment]  asDWHERETd.[ID] =D.[PID])SELECT [ID],[conjunction]  fromTempdeptment

View Code

Operation Result:

Insus.net previously did not implement recursion in SQL, now there is just one instance, is the practice.