SQL server is there recursive reserve word?
Ms Sql recursive CTE syntax has no RECURSIVE keyword See
https://technet.microsoft.com/en-us/library/ms186243(v=sql.105).aspx
Ie. CTE of the form

WITH cte_name ( column_name [,...n] )
AS
(
–- Anchor member 
UNION ALL
–- Recursive member 
)


is recursive when Recursive member references  cte_name. For example

WITH node_rec AS (
    SELECT TOP(10) 1 AS depth, node AS path, *
    FROM   nodes
    WHERE  parent IS NULL
    UNION ALL
    SELECT r.depth + 1, r.path +'/'+ n.node, n.*
    FROM   node_rec r 
    JOIN   nodes n ON n.parent = r.node
    WHERE  r.depth &lt; 4
)