如何递归读取所有记录并按级别深度TSQL显示

WITH RecursiveCTE (ID, ParentID, Name, Depth)
AS
(
    SELECT ID, ParentID, Name, 0 AS Depth
    FROM TableName
    WHERE ParentID IS NULL
    UNION ALL
    SELECT Child.ID, Child.ParentID, Child.Name, Parent.Depth + 1 AS Depth
    FROM TableName AS Child
    INNER JOIN RecursiveCTE AS Parent ON Child.ParentID = Parent.ID
)
SELECT ID, ParentID, Name, Depth
FROM RecursiveCTE
ORDER BY Depth, Name