snf全栈工程师

摘要： with area as( select Orderid,FatherOrderid,rtrim(PartName) as NodeText,left('00',2-len(row_number() over (order by partindex)))+ CONVERT(varchar,row_number() over (order by partindex)) as d,0 as liu,op as 这列不用 from #Temp_Tree where FatherOrderid = 419197 union all select a.Orderid,a.FatherOr 阅读全文