sql server CTE遞迴使用測試

標籤：

--CTE遞迴查詢if(object_id(N‘menu‘) > 0)drop table menuCREATE TABLE MENU  (    name nvarchar(50) NOT NULL PRIMARY KEY,    senior nvarchar(50) NULL);  INSERT INTO MENU values    (‘檔案‘,NULL),    (‘建立‘,‘檔案‘),    (‘項目‘,‘建立‘),    (‘項目11111‘,‘項目‘),    (‘項目22222‘,‘項目‘),    (‘項目33333‘,‘項目‘),    (‘使用當前串連查詢‘,‘建立‘);    WITH lmenu(name,senior,level) as (    SELECT NAME,SENIOR,0 level FROM MENU WHERE name = ‘建立‘    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遞迴使用測試