实例 :
1 select AuxTypeName + ',' from 2 ( 3 SELECT DISTINCT(AuxTypeName) FROM _VIPHall_Link_AuxType 4 LEFT JOIN dbo.[_VIPHall] ON [_VIPHall_Link_AuxType].VIPHallID = [_VIPHall].VIPHallID 5 LEFT JOIN dbo._Dim_VIPHall_AuxType ON [_Dim_VIPHall_AuxType].AuxTypeID = [_VIPHall_Link_AuxType].AuxTypeID 6 WHERE [_VIPHall].VIPHallID = 157 7 ) AS tmp 8 for xml path('') 9
样例 :
1 select( select CAST(字段 as varchar)+',' 2from 表 for xml path('') ) as A