SQL将一列转换成一行，并将这一行形成新的列

1. 查询出来要转换的数据

SELECT name FROM dbo.base_pay_type WHERE is_enabled = 1

数据如图：

2.将查询到的数据转换成行，以逗号隔开，以【】包裹

SELECT STUFF((SELECT  '[' + name + '],'  
FROM(SELECT name FROM dbo.base_pay_type WHERE is_enabled = 1) a  FOR  XML PATH('')  ), 1,0, '') AS Name 

数据如图：

3，去掉最后一个逗号

SELECT LEFT(a.Name,LEN(a.Name)-1) AS Name FROM (SELECT STUFF((SELECT  '[' + name + '],'  
FROM(SELECT name FROM dbo.base_pay_type WHERE is_enabled = 1) a  FOR  XML PATH('')  ), 1,0, '') AS Name ) AS a

数据如图：