All geek questions in one place

What should replace the SQL keyword "ISABOUT" [deprecated?]?

In MS SQL full-text search, I use ISABOUT in my queries.

For example, this should return the top 10 ProductIDs (PK) with the RANK field in the ProductDetails table

 SELECT * FROM CONTAINSTABLE( ProductDetails, *, ISABOUT("Nikon" WEIGHT (1.0), "Cameras" Weight(0.9)), 10 )

However, according to the SQL documentation, ISABOUT deprecated.

So, I have two questions:

  • What is replaced by ISABOUT on?
  • REALLY I NEEDED any additional SQL Command there? (IOW, would you just put the search phrase "Nikon Cameras" better?)

What I originally tried to accomplish here is the weighted first word, the highest, then the second word below, and continue to decline to 0.5, where I would simply rate the remaining words at 0.5.

My logic (and perhaps it was spoiled) was that people, the most relevant search words, usually occur at the beginning of a phrase (in English).

  • Am I going about it wrong?
  • Is there a better way?
  • Am I asking too many questions? (^ _ ^)

Thank you all for your time ...

+4
source share
2 answers

Your link above refers to Enterprise Search, but for full-text SQL Server searches, ISABOUT is still supported as part of the CONTAINS predicate and CONTAINSTABLE .

This issue was also addressed in a post on the MSDN SQL Server Search forum .

+6
source

ISABOUT adds custom weights to your words, which help to rank returned documents. For CONTAINS() it does not do any ranking; this form has no effect.

+2
source

Source: https://habr.com/ru/post/1306052/

More articles:


All Articles