34,838
社区成员




DECLARE @result nvarchar (4000)
select @result=isnull(@result,'')+' '+item1+' '+item2+' '+item3+' ' from tb
DECLARE @result nvarchar (4000)
select @result=isnull(@result,'')+' '+item1+' '+item2+' '+item3+' ' from tb
--或者整列整列的处理也可以
DECLARE @result nvarchar (4000)
set @result=''
select @result=@result+item1+' ' from tab1
select @result=@result+item2+' ' from tab1
select @result=@result+item3+' ' from tab1
select @result=@result+item4+' ' from tab1
DECLARE @result nvarchar (4000)
set @result=''
select @result=@result+' '+item1+' '+item2+' '+item3+' ' from tab1