日期:2014-05-17 浏览次数:20469 次
declare @test table(col1 varchar(1),col2 int,col3 varchar(3)) select (','+col3) as 'test' from @test for xml path('')
select stuff((select ','+col3 from @test for xml path('')),1,1,'') as 'test'