《《《《《《《《内容已删除》》》》》》》》》

FREETEXTTABLE

FREETEXTTABLE

FREETEXTTABLE

FREETEXTTABLE

1

FREETEXTTABLE can be referenced in the FROM clause of a SELECT statement like a regular table name .

像常规表名称一样，FREETEXTTABLE 也可以在 SELECT 语句的 FROM 子句进行引用。

2

CONTAINSTABLE and FREETEXTTABLE rowset-valued functions can be used in the FROM clause of a SELECT statement .

CONTAINSTABLE 和 FREETEXTTABLE 行集值函数可以在 SELECT 语句的 FROM 子句中使用。

3

CONTAINSTABLE and FREETEXTTABLE are also used to specify selection criteria .

CONTAINSTABLE 和 FREETEXTTABLE 也用来指定选择条件。

4

The CONTAINSTABLE and FREETEXTTABLE functions are used to specify full-text queries that return relevance rankings for each row .

CONTAINSTABLE 和 FREETEXTTABLE 函数用来指定全文查询以返回每行的相关性排名。

5

To limit results and increase performance , use the TOP_N_BY_RANK option of the FREETEXTTABLE and CONTAINSTABLE syntax .

若要限制结果数并提高性能，请使用 FREETEXTTABLE 和 CONTAINSTABLE 语法的 TOP_N_BY_RANK 选项。

6

FREETEXTTABLE uses the same search conditions as the FREETEXT predicate .

FREETEXTTABLE 使用与 FREETEXT 谓词相同的搜索条件。

7

In CONTAINSTABLE and FREETEXTTABLE to specify the number of matches according to rank you want returned .

根据希望返回的排名来指定匹配项数量。

8

If you only require full-text key or rank information , use CONTAINSTABLE or FREETEXTTABLE instead of CONTAINS or FREETEXT , respectively .

如果只需要全文键或排名的信息，请分别使用 CONTAINSTABLE 或 FREETEXTTABLE ，而不要使用 CONTAINS 或 FREETEXT 。

9

CONTAINSTABLE and FREETEXTTABLE both return a table of zero , one , or more rows, so they must always be specified in the FROM clause .

CONTAINSTABLE 和 FREETEXTTABLE 都返回包含零行、一行或多行的表，因此它们必须始终在 FROM 子句中指定。

热词推荐

大家在看