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