交叉应用FREETEXTTABLE

Question

MS SQL Server2005: table1具有全文索引。我想在一个查询中对它运行多个freetexttable搜索，但我的两次尝试都失败了。如有任何帮助，将不胜感激，谢谢！附注：如果sql 2008解决了这个问题，我愿意升级到sql 2008 :)

CREATE FUNCTION fnt_FullTextSearch ( @s NVARCHAR(4000) )
RETURNS TABLE
AS
  RETURN
    ( SELECT [key], [rank]
        FROM FREETEXTTABLE(table1, *, @s) )

DECLARE @terms TABLE ( term VARCHAR(MAX) )
INSERT INTO @terms VALUES ( 'flu' )
INSERT INTO @terms VALUES ( 'acid' )

-- The inline function "..." cannot 
-- take correlated parameters or subqueries 
-- because it uses a full-text operator.
SELECT ft.[key], ft.[rank]
    FROM @terms 
        CROSS APPLY fnt_FullTextSearch(term) ft

--syntax error on term
SELECT ft.[key], ft.[rank]
    FROM @terms 
        CROSS APPLY FREETEXTTABLE(table1, *, term)

Answer 1

也许是因为你在第二条语句中遗漏了别名？

SELECT FT.[key], FT.[rank]
    FROM @terms 
        CROSS APPLY FREETEXTTABLE(table1, *, term) FT

听起来像是trivial...but，我看不出还有什么其他的原因会失败！