将行编号转换为一个字符串解决方案二

DECLARE @temp TABLE (Id INT,Value CHAR (5))
INSERT INTO @temp
SELECT '1'
,'09:01'
UNION
SELECT '1'
,'12:05'
UNION
SELECT '2'
,'08:04'
UNION
SELECT '2'
,'17:09'
UNION
SELECT '3'
,'99888'

SELECT *
FROM @temp

SELECT id

, stuff ((SELECT ','+ rtrim (value)
              FROM @temp
              WHERE id = a.id
                  FOR xml path ('')),1,1,'') AS [values]
FROM @temp a
GROUP BY a.id

使用函数字符拼凑函数 stuff

Stuff(expression1_Str,startIndex,lengthInt,expression2_Str)

函数共有四个参数，其功能是将expression1_Str中

　　　　　　　　　自startIndex位置起删除lengthInt个字符，

                       然后将expression2插入到expression1_Str中的startIndex位置

 

 

 

字符串连接（行转列问题）

SELECT @Results = ISNULL(@Results + ',', '') + CAST(tn.NewsId AS VARCHAR) FROM dbo.TB_News tn ORDER BY tn.NewsId DESC SELECT @Results

 

字符串合并

Declare @Results varchar(MAX)
SELECT @Results = ISNULL(@Results + ''', ''', '') + CAST(tn.ExternalName AS VARCHAR)
FROM ConfigurationMaster.dbo.Currency tn
WHERE tn.CurrencyDecimalPlaceCnt = 3
ORDER BY tn.ExternalName ASC
SELECT @Results