[sql]匹配标题中出现最多关键字的结果

SELECT RequirementId,Title,ProjectId,Keywords, 0 as keywordcount

INTO #t1

FROM

(

select *

from dbo.Requirement

where Keywords is not null and Keywords <> ''  and ProjectId=11

and (Keywords like '%关键字1%' or  Keywords like '%关键字2%' or Keywords like '%关键字3%')

) AS TEMPTABLE

select * from #t1 order by keywordcount desc, RequirementID desc

update #t1

set keywordcount = keywordcount +1

where Keywords like '%关键字1%'

update #t1

set keywordcount = keywordcount +1

where Keywords like '%关键字2%'

update #t1

set keywordcount = keywordcount +1

where Keywords like '%关键字3%'

select * from #t1 order by keywordcount desc, RequirementID desc

drop table #t1