开发者

Problem with Full text Searching

开发者 https://www.devze.com 2022-12-23 12:14 出处:网络
I am searching in resumes weather the word is exist or not i am using the below query Case1: select top(10) c_resume_text from sntbl_candidates

I am searching in resumes weather the word is exist or not

i am using the below query

Case1:

select top(10) c_resume_text from sntbl_candidates
where contains(c_resume_text,'"a/dm"')

in the above example only it is not working properly .It showing resumes even though there is no text like开发者_运维知识库 that.

In Messages i am getting the following message.

Informational: The full-text search condition contained noise word(s).

if i try with

Case 2:

select top(10) c_resume_text from sntbl_candidates
where contains(c_resume_text,'"a/d')

i am getting proper results in case 2

can any one suggest me what to do.

Thanks


The answer to this question may get you what you need to know. Dropping noise words in SQL Server 2005 full text indexing

0

精彩评论

暂无评论...
验证码 换一张
取 消