select * FROM (
SELECT DISTINCT SysMenu_ID FROM SysModuleFunction
)T
<span style="color:#ff0000;">OUTER apply</span> (
select SysFunction_ID=<span style="color:#ff0000;">replace(replace((select SysFunction_ID from SysModuleFunction where SysMenu_ID=T.SysMenu_ID for xml auto),'<SysModuleFunction SysFunction_ID="',''),'"/>',',')</span>
)N
SQL查询拼接
最新推荐文章于 2023-02-02 09:44:57 发布