当我们使用“或”时，ContainsTable功能无法正常工作运营商。 [英] ContainsTable funtion is not working when we are using "or" operator.

问题描述

ContainsTable功能无效。

ContainsTable funtion is not working when we are using or operator.

SELECT top 100
D.[name], CT.Rank AS RANKR
FROM ContainsTABLE ([DocumentSemantics], [file_stream],
      'java and j2ee and sql or oracle' ) AS CT
 INNER JOIN dbo.[DocumentSemantics] AS D
  ON CT.[KEY] = D.[path_locator]
  order by rankr desc

结果不是如果使用或操作员不重新。





请帮助我........

Result is not releavant if use or operator .


Please help me........

推荐答案

组合 AND 和 OR 时需要小心。请检查优先级并根据需要使用括号。

You need to be careful when combining AND and OR . Please check the precedence and use parentheses as necessary.

这篇关于当我们使用“或”时，ContainsTable功能无法正常工作运营商。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！