Archive

Posts Tagged ‘Full-Text Search’

SQL Server 2008 Full-Text Search – Getting list of system stopwords

November 1st, 2009 Zaur Bahramov No comments

This will get the list of all languages supported by the SQL Server 2008 Full-Text Search:

Code Snippet
  1. – to determine run_value corresponding to locale [LCID - LoCale IDentifier]
  2. SELECT lcid, name FROM sys.fulltext_languages

Result:

lcid        name
———– ———————————————–
5124        Chinese (Macau SAR)
4100        Chinese (Singapore)
3098        Serbian (Cyrillic)
3082        Spanish
3076        Chinese (Hong Kong SAR, PRC)
2074        Serbian (Latin)
2070        Portuguese
…………….
1036        French
1033        English
1031        German
1028        Traditional Chinese
1027        Catalan
1026        Bulgarian
1025        Arabic
76            76
69            69
25            25
13            13
1              1
0              Neutral

(53 row(s) affected)

The following query will bring the list of system stopwords corresponding to the English locale:

Code Snippet
  1. – list all stopwords corresponding to 1033 locale [English]
  2. SELECT * FROM sys.fulltext_system_stopwords
  3.     WHERE language_id = 1033

 

When this query is run 154 records containing system stopwords will be returned.

Categories: T-SQL Tags: , ,