摘要:
SELECT RequirementId,Title,ProjectId,Keywords, 0 as keywordcountINTO #t1FROM(select *from dbo.Requirementwhere Keywords is not null and Keywords <> '' and ProjectId=11and (Keywords like '%关键字1%' or Keywords like '%关键字2%' or Keywords like '%关键字3%')) AS TEMPTABLEs 阅读全文