Microsoft SQL Server T-SQL in 10 Minutes, Sams Teach Yourself by Ben Forta

Author:Ben Forta [Forta, Ben]
Language: eng
Format: azw3, pdf
Publisher: Pearson Education
Published: 2016-12-28T05:00:00+00:00

* * *

Note: Assigning Search Term Weights

The rankings assigned in this example assume that all words are equally important and relevant. If this is not the case, and some words are more important than others, then the ISABOUT() function can be used to assign weight values to specific words. The full-text search engine will then use these weight values when determining rankings.

* * *

Summary

In this lesson, you learned why full-text searching is used, and how to use the T-SQL FREETEXT() and CONTAINS() functions to perform these searches. You also learned how to use Boolean operators, wildcards, proximity searches, inflectional matches, and search rankings.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.