本文介绍了SQL Server全文搜索不适用于我的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在SQL Server中使用全文搜索时遇到问题.我的查询:
I have problem with Full Text Search in SQL Server.My query:
Select [Name] From [POI] Where Contains([Name], N'"bank of*"');
查询不返回任何行.但是表有几行包含"...的行"当我删除"of"一词时,一切正常.请帮助解决此问题.
Query returns no rows.But table has several rows that contains "bank of ..."When I delete the word "of" everything works.Please help to solve this problem.
推荐答案
如其他问题所述,索引中不包括干扰词. "of"是一个干扰词,它将解释您所看到的行为.
As described in this other question Dropping noise words in SQL Server 2005 full text indexing, noise words are not included in the indexing. "of" is a noise word, which would explain the behavior you're seeing.
另请参阅:
其中包含建议
ALTER FULLTEXT INDEX ON table
SET STOPLIST OFF;
这篇关于SQL Server全文搜索不适用于我的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!