SQL Server CTE recursive use test

--cte recursive query if (object_id (N ' menu ') > 0) drop table menucreate Table menu  (    name nvarchar () not NULL PRIMARY key,< C3/>senior nvarchar (+) NULL);  INSERT into MENU values    (' file ', NULL), (' New ', ' file '), (' Project ', ' new '), (' Project    11111 ', ' Project '), (' Project    22222 ', ' Project '),    (' Project 33333 ', ' project '),    (' Use Current connection query ', ' new ');    With Lmenu (Name,senior,level) as (    SELECT name,senior,0 level from MENU WHERE name = ' new '    UNION all    SELECT A.name,a.senior,b.level+1 from MENU a,lmenu b    where a.senior = b.name) SELECT * from  Lmenu

　　

SQL Server CTE recursive use test