SQL列转行用逗号隔开时间:2023-03-09 17:34:52 declare @result varchar(255) set @result = ” select @result = @result + cast(F_IT_FWID as varchar(255)) +‘,’ from [TJFX].[dbo].[TB_JG_SJTJFXB201412] where F_IT_FWLX=1 select left(@result,len(@result) – 1) as fwid 转自http://ibear.me/2015/08/15/39