create table #
(
a int,
b varchar(10)
)
insert into #
select 1,'aaaa' union all
select 2,'bbbb' union all
select 3,'cccc' union all
select 4,'dddd' union all
select 5,'eeee' union all
select 6,'ffff'
declare @str varchar(100)
set @str=''
select @str=@str+b+'/' from #
select left(@str,len(@str)-1) as 结果