问题描述
是否可以在大字符串中转换一列双打:
Is it possible to convert a column of doubles in a big string:
类似于:
att1 ---------- 123.2 3.6 6.77 23.43 4.78 7.6 123.2 9.6 1.77 3.43 24.78 76.6 411.5 346.5 975.75 162.788 4.5 16.2 324.5 746.5 975.75 12.788 24.5 6.2 to string = " 123.2, 3.6, 6.77, 23.43, 4.78, 7.6, 123.2, 9.6, 1.77, 3.43, 24.78, 76.6, 411.5, 346.5, 975.75, 162.788, 4.5, 16.2, 324.5, 746.5, 975.75, 12.788, 24.5, 6.2 ";
推荐答案
declare @List varchar(max) select @List = isnull(@List + ',', '') + cast(ColumnName as varchar) from MyTable print @List
例如:
declare @List varchar(max) select @List = isnull(@List + ',', '') + cast(object_id as varchar) from sys.objects print @List
或
select stuff( (select ',' + cast(object_id as varchar) from sys.objects for xml path('')), 1, 1, '')