SQL2005递归

string sql = @"WITH locs(id,levelname,parentid,flag,loclevel) AS (SELECT id,levelname,parentid,flag,0 as loclevel FROM T_Level

where id="+LevelId+" UNION ALL SELECT l.id,l.levelname,l.parentid,l.flag,loclevel+1 FROM T_Level l INNER JOIN locs p ON l.parentid=p.id ) SELECT * FROM locs";