SQL查询分类表节点及所有父节点记录

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

declare @classcode varchar(128) SET @classcode = '1062' ;WITH T AS (   SELECT classcode,          parentcode,          classname   FROM   sys_wxzskclass   WHERE  classcode = @classcode   UNION ALL   SELECT A.classcode,          A.parentcode,          A.classname   FROM   sys_wxzskclass AS A          JOIN T AS B ON A.classcode = B.parentcode ) SELECT * FROM T ORDER BY classcode