create table T(ColumnA int, ColumnB varchar(10), ColumnC int)
insert T select 1, 'abc', '5'
union all select 1, 'def', '4'
union all select 1, 'ghi', '9'
union all select 2, 'jkl', '8'
union all select 2, 'mno', '3'
declare @s1 varchar(8000), @s2 varchar(8000)
select @s1='', @s2=''
select @s1=@s1+ColumnB from T order by ColumnB
print @s1
select @s2=@s2+cast(ColumnC as varchar) from T order by ColumnC
print @s2
declare @s1 varchar(1000)
set @s1=''
declare @s2 varchar(1000)
set @s2=''
select @s1=@s1+columnb from tb order by columnb
select @s2=@s2+rtrim(cast(columnc as varchar(10))) from tb order by columnc
declare @s varchar(1000)
set @s=''
declare @ss varchar(1000)
set @ss=''
select @s=@s+columnb,@ss=@ss+cast(columnc as varchar(10)) from test order by columnc
select @s,@ss