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
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步