数据库输出数据问题,把数据集转换成字符串

  with a as(

	select tId, tName, tpId from S_OEMType where tId='1'

	union all

	select x.tId,x.tName,x.tpId from S_OEMType as x,a 

	where x.tpId=a.tId

        )

	declare @s varchar(max)

	select @s=isnull(@s+',','')+tId FROM A

	PRINT @S 

select [tId]=stuff((select '、'+ [tId]  from a for xml path('')), 1, 1, '') 

----------------------------------------------------

/*如何将一列中所有的值一行显示

数据源

  a

  b

  c

  d

  e

结果

a,b,c,d,e

*/



create table tb(col varchar(20))

insert tb values ('a')

insert tb values ('b')

insert tb values ('c')

insert tb values ('d')

insert tb values ('e')

go



--方法一

declare @sql varchar(1000)

set @sql = ''

select @sql = @sql + t.col + ',' from (select col from tb) as t

set @sql='select result = ''' + left(@sql , len(@sql) - 1) + ''''

exec(@sql)

/*

result     

---------- 

a,b,c,d,e,

*/



--方法二

declare @output varchar(8000)

select @output = coalesce(@output + ',' , '') + col from tb

print @output

/*

a,b,c,d,e

*/



---方法三

declare @s varchar(1000)

select @s=isnull(@s+',' , '')+col from tb

select @s

/*

a,b,c,d,e

*/



drop table tb





-------------

declare @s varchar(8000)



select @s=isnull(@s+',','')+tId FROM A 



PRINT @S