MS SQL Server 2005:表1具有全文索引。我想在一个查询中对它运行多个freetexttable搜索,但两次尝试都失败了。任何帮助都将不胜感激,谢谢!p、 如果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)