select stuff((select ','+[Categories] from [sys_Category] where [CategoriesNo] in (105,301,601) for xml path('')),1,1,'')
sqlserver将查询的单列结果集拼成一行字符串用逗号分隔
最新推荐文章于 2023-04-27 11:50:41 发布
select stuff((select ','+[Categories] from [sys_Category] where [CategoriesNo] in (105,301,601) for xml path('')),1,1,'')