关于sql2008 权重问题

[别样苍茫]

select * from ExpertsQuestions where contains(title,'ISABOUT ("澳大利亚" weight(0),"留学" weight(1))')

SELECT * FROM ExpertsQuestions WHERE CONTAINS(title,'ISABOUT (澳大利亚 weight(1),留学 weight(0))')


这两个语句查询出的结果是一模一样的，不知是我权重加错了，还是语句有问题，请SQL牛人帮我看看。。谢谢

[liyutun]

好复杂啊，都看不懂怎么办

[永生天地]

联机丛书里写了 weight值不影响查询结果。

没进行具体研究，lz可以看看 联机丛书

[别样苍茫]

解决了

SELECT E.Title,E.Content, KEY_TBL.RANK 
FROM ExpertsQuestions AS E INNER JOIN
CONTAINSTABLE(ExpertsQuestions, title, 'ISABOUT ( 澳大利亚  weight(1.0),留学  weight(0.0) )' ) AS KEY_TBL
ON E.ID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK

但是感觉有点复杂，不知道是否可以再优化优化