SQL Server 将某一列的值拼接成字符串

实例 ：

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

 

posted @ 2020-06-02 11:02  daochi  阅读(487)  评论(0)  编辑  收藏  举报