sql 将某一列的值拼接成字符串

declare @str varchar(200)
set @str=''   -- 必须先赋值
select  @str=@str+cast(tb.[objid] as varchar(10))+',' from(
select [objid],sfrq  from  tablename ) tb order by tb.sfrq
 print @str

 

转载于:https://www.cnblogs.com/xiaozizi/p/5820695.html