Geek Answers Handbook

Query SQl Server 2005 Full-Text Noise / Stop Word Search

Is it possible to get a list of Full Text Search words / stop words from SQL Server 2005 by querying the database?

I know that noise words are in the text file ~ / FTData / noiseEng.txt, but this file is not available for our application.

I look at sys.fulltext_ * tables, but they don't seem to have words.

+5
source share
2 answers

This seems to be impossible in SQL 2005, but is in SQL Server 2008.

Advanced Queries for Using SQL Server 2008 Full Text Search StopWords / StopLists

, SQL Server 2008. , SQL Server 2005.

- - - SQL Server 2008

SQL Server 2005 -. SQL Server 2008 , SQL Server 2008. FTDATA \ FTNoiseThesaurusBak, SQL Server 2008 -. -, . .

+2

\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData .

    Public Function StripNoiseWords(ByVal s As String) As String
        Dim NoiseWords As String = ReadFile("/Standard/Core/Config/noiseENU.txt").Trim
        Dim NoiseWordsRegex As String = Regex.Replace(NoiseWords, "\s+", "|") ' about|after|all|also etc.
        NoiseWordsRegex = String.Format("\s?\b(?:{0})\b\s?", NoiseWordsRegex)
        Dim Result As String = Regex.Replace(s, NoiseWordsRegex, " ", RegexOptions.IgnoreCase) ' replace each noise word with a space
        Result = Regex.Replace(Result, "\s+", " ") ' eliminate any multiple spaces
        Return Result
    End Function
0

More articles:


All Articles