摘要: 倒序--》从子节点查到顶级父节点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... 阅读全文
posted @ 2012-06-15 13:20 K-Show 阅读(224) 评论(0) 推荐(0) 编辑