该如何把Oracle start with 改 sqlserver？能实现吗？

Question

select distinct o.orgid from baf_org_organization o CONNECT BY prior o.parentorgid = o.orgid START WITH o.orgid='11' and o.isvalid='Y';

Answer 1

with temp(orgid,parentorgid) as
(
select distinct o.orgid,o.parentorgid from baf_org_organization o where o.orgid='11' and o.isvalid='Y'
union all
select distinct o.orgid,o.parentorgid from baf_org_organization o
inner join temp b on o.parentorgid = b.orgid
)
select orgid from temp
试下，对Oracle的语法不是太了解，我理解的是这个意思。

Answer 2

sqlserver没有这个写法