用一条sql递归抓取上下级的所有数据并把名称拼接起来
WITH Area2( id,parentid, code, name, parentcode , eLevel,fullname) AS ( SELECT id,parentid,code, name, parentcode, 0 AS eLevel,CONVERT(varchar(255),name )as fullname FROM Fit_Area WHERE ParentId =0 UNION ALL SELECT e.id,e.ParentId,
原创
2021-11-17 10:33:53 ·
2043 阅读 ·
0 评论