什么是SQL关键字“ISABOUT” [已弃用？]替换为？ [英] What should the SQL keyword "ISABOUT" [deprecated?] be replaced with?

问题描述

在MS SQL全文搜索中，我在查询中使用了ISABOUT。例如，这应该以 RANK返回前10位 ProductIDs （PK）。 ProductDetails 表中的字段

  SELECT * 
 FROM CONTAINSTABLE（ProductDetails，*，ISABOUT（NikonWEIGHT（1.0），CamerasWeight（0.9）），10）
  

但是，根据 SQL文档 ISABOUT 已弃用。

所以，我有两个问题：

1. 什么是 ISABOUT 被替换为？


2. 需要额外的 SQL命令那里？ （IOW，会把搜索词'Nikon Cameras'变得更好吗？）

我原本想完成的工作是加权第一个单词最高，然后第二个单词降低，并继续下降到0.5，我将其余的单词排在0.5。

我的逻辑（也许它是有缺陷的是，人们最相关的搜索词通常发生在词组的开头（英语）附近。

• 错误的方式？


• 有没有更好的方法？


• 我是否问了太多问题？ （^ _ ^）

非常感谢您的时间...

解决方案

上面的链接是指企业级搜索，但对于SQL Server全文搜索，仍然支持ISABOUT作为包含谓词和 CONTAINSTABLE 函数。

一篇文章到MSDN SQL Server搜索论坛。

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), "Cameras" Weight(0.9)), 10 )

However, according to the SQL Documentation ISABOUT is deprecated.

So, I have two questions:

1. What is ISABOUT being replaced with?
2. DO I even NEED any extra SQL Command there? ( IOW, would just putting the search phrase 'Nikon Cameras' be better? )

What I was originally trying to accomplish here was to weight the first word the highest, then the second word lower, and keep descending to 0.5 where I would just rank the remaining words at 0.5.

My logic ( and perhaps it's flawed ) was that people's most relevant search words usually happen near the beginning of a phrase ( in English ).

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

Thanks all for your time...

解决方案

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

This question was also covered in a post to the MSDN SQL Server Search forum.

这篇关于什么是SQL关键字“ISABOUT” [已弃用？]替换为？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！