如何提取两个字符串中相同的特定的字段,再加100分
function f_mergme(@U_ID int,@charater varchar(10))
returns varchar(8000)
as
begin
declare @s nvarchar(4000)
set @s=''
select @s=@s+@charater+s
from(
select top 100 percent
s=substring(a.R_MOdule,b.id,charindex(@charater,a.R_MOdule+@charater,b.id)-b.id)
from tb a,序数表 b
where a.U_ID=@U_ID and b.id<=len(a.R_MOdule) and substring -----将原来---的4改为@U_ID
(@charater+a.R_MOdule,b.id,1)=@charater
group by substring(a.R_MOdule,b.id,charindex(@charater,a.R_MOdule+@charater,b.id)-b.id)
having count(*)=(select count(*) from tb where U_ID=@U_ID) -----将原-----来的4改为@U_ID
order by min(id))a
return(stuff(@s,1,1,'')
)
end
函数如上,请问是什么原理呢