sqlserver 递归

with temp(_view_id,_view_name,_view_value,_parent_id) as

(

select view_id,view_name,view_value,parent_id from view_config  where parent_id =0

union all

select view_id,view_name,view_value,parent_id 

from view_config

inner join temp

on _view_id = parent_id

) select * from temp