Shulou(Shulou.com)05/31 Report--

SQL Server how to achieve full-text indexing services, I believe that many inexperienced people are helpless, this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

SQL7 full-text search and IndexServer search are very similar. Contains AND,OR,NOT Logical expressions can be conveniently used in Contains Example: Select user name from member where contains (userinfo,'"author "AND" carpenter "') Selectusernamefrommemberwherecontains (userinfo,'"author "OR" carpenter "') Selectusernamefrommemberwherecontains (userinfo,'"author"ANDNOT"carpenter"') NEAR This is a keyword that is not present in ordinary logical expressions. It means simply to find two words that are close together. Example: Select Content from Microsoft Record where contains (Content,'"Bill Gates"NEAR"Paul Allen"') This means finding the full text containing Bill Gates and Paul Allen, and the two words are not far apart. FORMSOFINFLECTIONAL This function can find various forms of words, such as past tense, plural, verb form, noun form, etc. Unfortunately, there is nothing useful for Chinese Example: SELECTProductNameFROMProductsWHERECONTAINS (ProductName,'FORMSOF(INFLECTIONAL,dry)') * This function can find the prefix of a word, but it is not useful for Chinese either. Example: SELECTProductNameFROMProductsWHERECONTAINS (ProductName,'"dis*"') ISABOUTWEIGHT This feature allows you to assign different weights to different criteria in a composite query to determine the order of the recordsets returned SELECTCategoryName, DescriptionFROMCategoryoriesWHERECONTAINS (Description,'ISABOUTspreadweight(.8),saucesweight(.4), religiesweight (.2))') Weight values can range from 0.0 to 1.0 ContainsTable Its use is basically the same as Contains, so I won't repeat it here. The point to mention is that it returns a table for you to query further, not a query condition. FreeText If this method is used, then the query will use word segmentation technology to implement fuzzy query, and filter out some non-keywords, similar to FORMSOF in Containers, but unfortunately there is no support for Chinese Example: SELECTCategoryNameFROMClassiesWHERREFREETEXT (Description,'sweetcandybreadanddrymeat') FreeTextTable The difference between FreeText and FreeText is the same as the difference between Containers and ContainsTable.

After reading the above, do you know how to implement full-text indexing services in SQL Server? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.