如何在逗号分隔的字符串中获取多个列数据？ [英] How to get multiple column data in a comma separated string?

问题描述

我收到的资料如

Result
------
 10
 23 
 21

但我想获得以下格式的数据。 p>

But i want to get data in the following format.

Result
------
10, 23, 21

如何在查询中获取？
预先感谢任何帮助：）

How to get that in a Query? Thanks in advance for any help :)

推荐答案

b $ b有一个学生表，其studentName列的数据类型为nvarchar（50），然后下面的查询将给你学生名称作为逗号分隔值，

Here is one way, There is a student table having studentName column with datatype as nvarchar(50) then following query will give you student names as comma separated values,

DECLARE @VALUES NVARCHAR(1000)
SELECT @VALUES = COALESCE(@VALUES + ',','') + CAST(STUDENTNAME AS NVARCHAR(50)) FROM STUDENT
SELECT @VALUES

这篇关于如何在逗号分隔的字符串中获取多个列数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！