开发者

Problem with Full text Searching

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜