一（把多条记录合成一条）

 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 结果