declare @str varchar(8000)
set @str=''
select @str=@str+NO1+',' from table1
set @str=left(@str,len(@str)-1)
select @str
set @str=''
select @str=@str+NO1+',' from table1
set @str=left(@str,len(@str)-1)
select @str
select * from (select distinct NO1 from table1) as TempTB
create function LinkJob(@Col varchar(20))
returns varchar(200)
as
begin
declare @Str varchar(200)
怕段字符串出现的位置,没有的的话累加@Str.......不详细写了
return @Str
end
insert #你的表 values (1,'aaa')
insert #你的表 values (2,'bbb,ccc,dddd')
insert #你的表 values (3,'aaa,bbb')
insert #你的表 values (4,'ccc,eee')
insert #你的表 values (5,'eee')
------下面开始处理-------
select top 8000 identity(int,1,1) id into #dali from sysobjects a,sysobjects bdeclare @a varchar(8000)
set @a=''select @a=@a+','+tt from (select distinct substring(','+b,id+1,charindex(',',','+b+',',id+1)-id-1) tt from #你的表 aa,#dali bb where substring(','+b,id,8000) like ',_%') tem order by ttselect right(@a,len(@a)-1) 结果drop table #daligo
drop table #你的表
----------
aaa,bbb,ccc,dddd,eee(所影响的行数为 1 行)