SQL Server Recursion

SQL Server does not have a statement similar to Oracle START with Name= ' xx ' CONNECT by PRIOR id=parent_id , but can be achieved by customizing the standard function +with statement, which is also a leverage

ALTER FUNCTION  [dbo].[recursionsyslocation](        --ADD The Parameters for the function here    @ParentId nvarchar( $))RETURNS TABLE  asRETURN (     with Temp([Id],[ParentID])     as    (        SelectId, ParentID fromsyslocationwhereParentID= @ParentId        Union  All        Selecta.id, A.parentid fromSyslocation aInner Join Temp  onA.parentid= Temp.[Id]            )        SelectS.id, S.parentid fromSyslocation swhereId=@ParentId    Union  All    Select *  from Temp)

SQL Server Recursion