日期:2014-05-18 浏览次数:20457 次
DECLARE @STR VARCHAR(8000) SELECT @STR=ISNULL(@STR+',','')+name FROM A SELECT @STR ------解决方案--------------------
select (select ltrim(NAME)+',' from tb for xml path('')) as a