sqlserver查询树表某个节点所有的子节点

最新推荐文章于 2023-12-15 14:24:11 发布

fw_br

最新推荐文章于 2023-12-15 14:24:11 发布

阅读量1.5k

点赞数

分类专栏： sqlserver sql 文章标签： sql sqlserver

本文链接：https://blog.csdn.net/u010060662/article/details/51544990

版权

sqlserver 同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

sql

3 篇文章 0 订阅

订阅专栏

DECLARE
    @s VARCHAR (MAX) SELECT
        @s = ',' + CAST (kindid AS VARCHAR(20)) + ''
    FROM
        treetable
    WHERE
        kindid = '25'
    WHILE @@ROWCOUNT > 0 SELECT
        @s =@s + ',' + CAST (kindid AS VARCHAR)
    FROM
        treetable
    WHERE
        charindex(
            ',' + CAST (kindid AS VARCHAR) + ',' ,@s + ','
        ) = 0
    AND charindex(
        ',' + CAST (parentkindid AS VARCHAR) + ',' ,@s + ','
    ) > 0 SELECT
        kindid,
        kindname,
        parentkindid
    FROM
        treetable
    WHERE
        charindex(
            ',' + CAST (kindid AS VARCHAR) + ',' ,@s + ','
        ) > 0