SELECT DISTINCT [values]=STUFF((SELECT ',' + [CLASS_NAME] FROM YGNW_TR_WARE_CLASS FOR XML PATH('')), 1, 1, '')
FROM YGNW_TR_WARE_CLASS
SQL 将行写进一列
最新推荐文章于 2021-03-17 17:37:30 发布
SELECT DISTINCT [values]=STUFF((SELECT ',' + [CLASS_NAME] FROM YGNW_TR_WARE_CLASS FOR XML PATH('')), 1, 1, '')
FROM YGNW_TR_WARE_CLASS