SQLserver2008 use expressions to recursively query _mssql2008

Copy Code code as follows:

--recursive subordinate by parent
With CTE (Id,parentid,text)
As
(--The parent
Select Id,parentid,text from treeview where ParentID = 450
UNION ALL
--Subordinate in recursive result set
Select T.id,t.parentid,t.text from TreeView as T
INNER join CTE as C on t.parentid = C.id
)
Select Id,parentid,text from CTE

---------------------

--child-level recursive parent
With CTE (Id,parentid,text)
As
(--Subordinate parent
Select Id,parentid,text from treeview where id = 450
UNION ALL
--Parent in recursive result set
Select T.id,t.parentid,t.text from TreeView as T
INNER join CTE as C on t.id = C.parentid
)
Select Id,parentid,text from CTE