Fulltext on Katmai

Key: We need to restart the Service of SQL Full-text Filter Daemon Launcher after changing something.

USE

SpiderMan

GO

EXEC

sp_configure 'show advanced option', '1'

;

RECONFIGURE

WITH OVERRIDE

;

go

exec

sp_configure 'default full-text language',

2052

RECONFIGURE

WITH OVERRIDE

;

go

EXEC

sys.sp_fulltext_load_thesaurus_file 2052

;

GO

--去掉tschs.xml中的注解

SELECT

*

FROM

Article

WHERE

FREETEXT(KeyWord,'', LANGUAGE 2052

);

SELECT

*

FROM

Article

WHERE

CONTAINS(KeyWord,'FORMSOF(THESAURUS,)'

);

SELECT

*

FROM

dbo.Article AS

FT_TBL

INNER JOIN FREETEXTTABLE(dbo.Article, KeyWord,

'',LANGUAGE 2052)

AS

KEY_TBL

ON FT_TBL.GUID = KEY_TBL.[KEY]

;

GO