SQL Server 转换选择一列并将其转换为字符串

问题描述

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

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"

推荐答案

你可以这样做:

小提琴演示

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 转换选择一列并将其转换为字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！