MSSQL 获取递归树形表数据

发布时间：2023-05-09 13:12:51 所属栏目：MsSql教程来源：

导读：根据节点主键，查询当前节点和所有子节点

WITH SOURCE AS (
SELECT * FROM TableName WHERE DeleteState = 0
),
LIST AS (
SELECT value FROM STRING_SPLIT('2111011043240001', ',')
)

根据节点主键，查询当前节点和所有子节点

WITH SOURCE AS (
SELECT * FROM TableName WHERE DeleteState = 0
),
LIST AS (
SELECT value FROM STRING_SPLIT('2111011043240001', ',')
),
RESULT AS (
SELECT SOURCE.* FROM SOURCE
INNER JOIN LIST ON SOURCE.Code = LIST.value
UNION ALL
SELECT SOURCE.* FROM RESULT
INNER JOIN SOURCE ON RESULT.Code = SOURCE.ParentCode
)
SELECT Code, ParentCode, NodeName, NodeIndex, IsLastNode FROM RESULT

（编辑：汽车网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!