根據(jù)指定節(jié)點(diǎn)ID獲取所有父節(jié)點(diǎn)
with temp as(
select * from dbo.Category where Id=493 --表的主鍵ID
union all
select t.* from temp,dbo.Category t where temp.Pid=t.Id --父級(jí)ID=子級(jí)ID
)select * from temp order by Level;
查詢結(jié)果
根據(jù)指定節(jié)點(diǎn)ID獲取所有子節(jié)點(diǎn)
with temp as(
select * from dbo.Category where Id=344 --表的主鍵ID
union all
select t.* from temp,dbo.Category t where temp.Id=t.Pid --子級(jí)ID==父級(jí)ID
)select * from temp;
查詢結(jié)果
