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