First, how to enable full-text search function in SQL 1. Verify that full-text search service is installed by the storage process FULLTEXTSERVICEPROPERTY (return information about full-text service level properties) to verify that the search service (full text component) is installed. Such as Select FullTextServiceProperty ('isfultextInstalled'): Returns 1 indicates that the full-text component is installed; returns 0 indicates that the full-text component is not installed; returns NULL indicates that the input is invalid or an error.
2. Start full-text search service (Mircosoft Search) 3, open database full-text index support to full-text index enable database: use northwindexec sp_fultext_database 'enable' From the database: use northwindexec sp_fulltext_database 'disable' Second, establish a full-text catalog 1, create a full-text catalog Use NorthwindExec sp_fulltext_catalog 'ft_ Catalog', 'create'2, rebuild full-text catalog Use NorthwindExec sp_fulltext_catalog' ft_ Catalog ',' rebulid'3, start filling Use NorthwindExec sp_fulltext_catalog full-text catalog 'ft_ Catalog', 'start_full'4, stop full-text catalog is filled Use NorthwindExec sp_fulltext_catalog 'ft_ Catalog', 'stop'5, delete the full-text catalog Use Northwind PK_ProductsExec sp_fulltext_catalog' ft_ Catalog ',' drop 'Third, create a unique index Use NorthwindExec full-text index data element 1, created for the table sp_fulltext_table 'Products', 'create', 'ft_ Catalog', 'PK_Products' 2, provided full-text index column names Use NorthwindExec sp_fulltext_table 'Products', 'create', 'ft_ Catalog', 'PK_Products' 3, provided full-text index column names Use NorthwindExec sp_fulltext_column 'Products', ProductName', 'add'GoExec sp_fulltext_column' Products', QuantityPerUnit ',' add'Go4, activate full-text index Use NorthwindExec sp_fulltext_table 'Products',' activate5, filled full-text catalogs Use NorthwindExec sp_fulltext_cata Log 'ft_ catalog', 'start_full' four, using Transact-SQL full-text search, we use Contains, FreeText, etc. '"c *" and "b *"') 2, retrieve in ProductName, including all columns of Chai Chang Tofu, all columns, using all columns, productswhere freetext (ProductName, 'Chai Chang Tofu') 5, full text query related system Storage Procedure (1) Start the full-text processing function of the database (sp_fulltext_datebase); (2) Establish a full-text directory (sp_fulltext_catalog)
