如何获取数据逗号分隔 [英] how to get data comma seprated
本文介绍了如何获取数据逗号分隔的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有像bellow这样的数据,
id name add dateEnterd
1 ab test 23-8-1988
1 ab test 23-8-1989
1 ab 测试 23-8-1990
1 ab test 22- 5-1999
如何获得类似
id的名称 add dateEnterd
1 ab test 23-8-1988,23-8-1989,23-8-1990,22-5- 1999
解决方案
检查此链接中的解决方案。
http://stackoverflow.com/questions/4380273/how-to-make-row-data-comma -separated-in-sql [ ^ ]
如果我正确理解你的问题,你需要SQL语句来分隔数据逗号
< pre lang =sql> DECLARE @ list VARCHAR (MAX)
SELECT @ list = COALESCE (@ list + ' ,',' ')+名称
FROM tablename where Id = @ id
SELECT @ list
声明 @ str varchar (< span class =code-digit> 1000 )
SELECT @ str = coalesce ( @ str + ' , ',' ')+ aX FROM ( SELECT CONVERT ( varchar ( 100 ),dateEnterd) AS X 来自 TableName 其中 ID = 1 和 name = '< /秒pan> ab' 和 [ add ] = ' test')
SELECT TOP 1 ID,NAME,[ add ], @ str FROM TableNAme WHERE ID = 1 和 name = ' ab' 和 [ add ] = ' test' ORDER BY ID ASC
请参考此链接以下
列值为逗号分隔的字符串 [ ^ ]
i have data like bellow,
id name add dateEnterd
1 ab test 23-8-1988
1 ab test 23-8-1989
1 ab test 23-8-1990
1 ab test 22-5-1999
how do i get somthing like
id name add dateEnterd
1 ab test 23-8-1988,23-8-1989,23-8-1990,22-5-1999
解决方案
Check the solution in this link.
http://stackoverflow.com/questions/4380273/how-to-make-row-data-comma-separated-in-sql[^]
If i am understanding your question correctly you require SQL statement to get data comma separated
DECLARE @list VARCHAR(MAX) SELECT @list = COALESCE(@list+',' ,'') + Name FROM tablename where Id=@id SELECT @list
declare @str varchar(1000) SELECT @str= coalesce(@str + ', ', '') + a.X FROM (SELECT CONVERT(varchar(100),dateEnterd) AS X from TableName where ID=1 and name='ab' and [add]='test') a SELECT TOP 1 ID,NAME,[add],@str FROM TableNAme WHERE ID=1 and name='ab' and [add]='test' ORDER BY ID ASC
Please refer this link bellow
Column Values as Comma Separated String[^]
这篇关于如何获取数据逗号分隔的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文