如何获取我的全文目录中使用的停用词的列表? [英] How to get a list of StopWords used in my FullText Catalog?

问题描述

是否可以获取我的SQL Server 2008全文目录使用的StopWord列表? 并在我的C#代码中使用它?

Is there a way to get the StopWord list that my SQL Server 2008 FullText Catalog is using? And use it, in my C# codebehind?

我想在用于搜索术语并突出显示它们的ASP.NET页面中使用它.

I want to use it in a ASP.NET page that I use to search terms and highlight them.

搜索页面和突出显示已经可以正常工作，但是我想改善突出显示.我不想突出显示我的StopWord列表中的一个单词.

The search page and the highlight are already working fine, but I want to improve the highlight. I don't want to highlight a word that is on my StopWord list.

推荐答案

在sql server management studio中，如果您从全文索引中询问属性，则可以看到其使用的非索引字表.请参见此处.

In sql server management studio if you ask the properties from the fulltext index you can see which stoplist it uses. See here.

然后，您可以使用系统视图 sys.fulltext_stoplists 和 sys.fulltext_stopwords 以获取停用词列表.

You can then use the system views sys.fulltext_stoplists and sys.fulltext_stopwords to get the list of stopwords.

这篇关于如何获取我的全文目录中使用的停用词的列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！