Stack Overflow
Stack Overflow

Questions tagged [isabout]

6 questions
10
votes
2 answers

SQL Server, ISABOUT, weighted terms

I am trying to figure out exactly how weighted terms work in an ISABOUT query in SQL SERVER. Here is where I currently am: Each query returns the following rows: QUERY 1 (weight 1): Initial ranking SELECT * FROM CONTAINSTABLE(documentParts, title,…
George Kosmidis
  • 359
  • 3
  • 13
4
votes
2 answers

What should the SQL keyword "ISABOUT" [deprecated?] be replaced with?

In MS SQL Full-text search, I'm using ISABOUT in my queries. For example, this should return the top 10 ProductIDs (PK) with a RANK Field in the ProductDetails Table SELECT * FROM CONTAINSTABLE( ProductDetails, *, ISABOUT("Nikon" WEIGHT (1.0),…
Armstrongest
  • 15,181
  • 13
  • 67
  • 106
3
votes
1 answer

Can I use a variable when using ISABOUT?

I'm trying to use a stored procedure to create a table that ranks posts by taking a topic name and using keywords and weights associated with that topic name to determine how they should be ranked. I've been trying to use CONTAINSTABLE and ISABOUT,…
kelsothenerd
  • 89
  • 1
  • 2
  • 6
2
votes
1 answer

How can I convert a user's search query into a MS SQL Full-Text Query Statement

I've search for answers for this and I can't seem to find an answer to what should be somewhat simple. This is related to another question I asked, but it's different. What's the best way to take a user's search phrase and throw it into a…
Armstrongest
  • 15,181
  • 13
  • 67
  • 106
0
votes
1 answer

How to get about.myname top level domain?

Sorry if this question sounds weird but I would like to learn about this more and searching this on google gives me results about other keywords after coming to the word about. I think that's how Google is designed to work, so it gives me no…
Alok Nath
  • 355
  • 1
  • 3
  • 11
0
votes
0 answers

TSQL CONTAINSTABLE ISABOUT() makes an incorrect match

I'm using SQL Server 2008 R2, and using CONTAINSTABLE ISABOUT() to identify key phrases in document titles. However, one specific key phrase is yielding false positives. They keyphrase is: "p-h-c industry" (without the quotes). Here's some sample…
andyabel
  • 335
  • 4
  • 15