from
to
实现sql:
select ','+CAST( id as varchar)+','+name+','+CAST( sex as varchar)+' ,'+CAST( age as varchar) from dbo.student for xml path('')
会发现id前多了一个逗号:
用stuff截取掉就可以了
完整sql:
select STUFF( (select ','+CAST( id as varchar)+','+name+','+CAST( sex as varchar)+' ,'+CAST( age as varchar) from dbo.student for xml path('')),1,1,'')