SQL Server转换选择一列并将其转换为字符串 [英] SQL Server convert select a column and convert it to a string

问题描述

是否可以编写一条从表中选择一列并将结果转换为字符串的语句?

Is it possible to write a statement that selects a column from a table and converts the results to a string?

理想情况下，我希望使用逗号分隔值.

Ideally I would want to have comma separated values.

例如，假设SELECT语句类似于

For example, say that the SELECT statement looks something like

SELECT column
FROM table
WHERE column<10

结果是带有值的列

|column|
--------
|  1   |
|  3   |
|  5   |
|  9   |

因此，我需要字符串"1、3、5、9"

I want as a result the string "1, 3, 5, 9"

推荐答案

您可以这样做:

小提琴演示

Fiddle demo

declare @results varchar(500)

select @results = coalesce(@results + ',', '') +  convert(varchar(12),col)
from t
order by col

select @results as results

| RESULTS |
-----------
| 1,3,5,9 |

这篇关于SQL Server转换选择一列并将其转换为字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！