sqlserver树形显示

发布时间：2020-12-12 16:07:27 所属栏目：MsSql教程来源：网络整理

导读：?with v_bm_dict_lab as(select *,cast(id as int ) px,cast(id as int ) px2 from BM_DICT_Lab where pid=0 union all select a.*,b.px,b.px2+ltrim(a.id) from BM_DICT_Lab a join v_bm_dict_lab b on a.pid=b.id )select * from v_bm_dict_lab order by p

?with v_bm_dict_lab as(select *,cast(id as int ) px,cast(id as int ) px2 from BM_DICT_Lab where pid=0 union all select a.*,b.px,b.px2+ltrim(a.id) from BM_DICT_Lab a join v_bm_dict_lab b on a.pid=b.id )select * from v_bm_dict_lab order by px,px2 ? ??

（编辑：李大同）

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