【sqlserver】递归查询

--向下递归查询

with temp (FolderName,id,ParentID)

as(

select a.FolderName,id,ParentID from NC_FolderInFo a where ParentID=105

union all

select m.FolderName,m.id,m.ParentID from NC_FolderInFo  as m

inner join temp as child  on m.ParentID = child.ID

)

select count(1) from temp t

inner join NC_FileInfo f on (t.id = f.FolderID_FK)

where IsEnable is null;