SQL SERVER 2008的全文检索

CREATE FULLTEXT INDEX ON SalesLT.Product

(  

　　Name LANGUAGE 1033,  

　　Color LANGUAGE 1033 ) 

KEY INDEX PK_Product_ProductID on (AdvFTCatalog) 

WITH (  CHANGE_TRACKING AUTO,  STOPLIST=SYSTEM )

GO

 

ALTER FULLTEXT INDEX ON SalesLT.Product ENABLE;

GO

 

--在MSSQL\FTDATA目录下修改词典，修改后为

<XML ID="Microsoft Search Thesaurus">
    <thesaurus xmlns="x-schema:tsSchema.xml">
    <diacritics_sensitive>0</diacritics_sensitive>
        <expansion>
            <sub>thin</sub>
            <sub>flat</sub>
        </expansion>
        <replacement>
            <pat>brick</pat>
            <pat>cherry</pat>
            <pat>magenta</pat>
            <pat>maroon</pat>
            <pat>rose</pat>    
            <pat>salmon</pat>
            <pat>vermilion</pat>
            <sub>red</sub>
        </replacement>        
    </thesaurus>
</XML>

 

SELECT ProductID,Name,Color

From SalesLT.Product

where FREETEXT(*,N'brick')

当查询brick时，根据词典自动换成red进行查询

 

exec sys.sp_fulltext_load_thesaurus_file 10333;

--查看支持的全部LCID列表 select * from sys.fulltext_languages