如何在sqlserver实现oracle中START WITH id = '' CONN

--oracle中的 START WITH id = '' CONNECT BY PRIOR id=p_id 如何在sqlserver中实现呢。
最好的解决办法：
WITH NODES   
 AS ( 
 SELECT * FROM DBO.T_ADMIN_RMS_CD C WHERE C.XH = '200909271033495d64880c587a4beda5bbac86fd92e0ec'
 UNION ALL   
 SELECT CSC.*FROM T_ADMIN_RMS_CD AS CSC INNER JOIN 
  NODES  AS RC ON CSC.FCDXH = RC.XH)  
  SELECT FROM T_ADMIN_RMS_CD WHERE XH IN (SELECT XH  FROM NODES N )  
 

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!