摘要：倒序--》从子节点查到顶级父节点alter proc Up_Qry_Select @CreditID int aswith Credit1 as(select ct.CreditID,ct.parentCreditID from dbo.Credit ct ),Credit2 as(select * from Credit1 where CreditID=@CreditID union all select Credit1.* from Credit2 inner join Credit1 on Credit2.parentCreditID=Cr... 阅读全文