Application of full text retrieval(1)

Basic knowledge
1. There is no full text search in the DeskTop version of SQL Server7.
2. A table can only have one full-text search.
3. The table being retrieved must have a single column unique index.
4. The full-text index is stored in the file system, not in the database.
5. The process of updating a full-text index is more time-consuming than a regular index, and it cannot be updated immediately by the database system like a regular index.
6. Full-text index is included in the full-text directory (Full-Text Catalog ), each database can contain one or more catalogs, but one catalog cannot belong to multiple databases.
7. Full text search can only be created on real tables, not views, system tables, or temporary tables.
8. Full text search will ignore some noise words (noise words), such as English a, the, and, Chinese '和', '是', etc.
9. If noise words are included in the query, an error will occur. These noises should be removed in the application. words.

Start full text search service.
Method A: Open the Support Services folder in Enterprise Manager and click Full-Text Select Start from the right-click menu of Search.
Method B: Select in the Services drop-down list of SQL Server Service Manager Microsoft Search and click the Start/Continue button.
Method C: Use net start mssearch command line mode.
Use the Full-Text Indexing Wizard.
step1. Select the database to be searched in Tools In the menu, select Full-text Indexing, enter the Welcome screen, and click next.
step2. Select the table to be retrieved and click next.
step3. Select a unique index and click next.
step4. Select the indexed column, click Add, and the column will be displayed in the right column. click next.
step5. Select a directory (select an existing directory, or create a new directory) and click next.
step6. Select or create population schedule (optional), click next.
step7. Click finish.
Use SQL-DMO (take VB as an example)
step1. Select Microsoft SQLDMO Object Library in the project's references.
step2. Create SQLServer object.
Dim objSQL As New SQLDMO.SQLServer
objSQL.Connect "localhost", "sa", ""
step3. Create a new directory and add it to the indexed database directory.
Dim objCatalog As New SQLDMO.FullTextCatalog
'make pubs Create a new catalog
objCatalog.Name for the full-text search database
objSQL.Databases("pubs").EnableFullTextCatalogs
' = "ftcPubsTest"
'Add the new catalog to the catalog collection
objSQL.Databases("pubs").FullTextCatalogs.Add objCatalog
step4. Create a full-text index on the table.
Dim objTable As New SQLDMO.Table
'Specifies the table to be indexed
Set objTable = objSQL.Databases("pubs").Tables("authors")
'Specify the catalog name and unique index name
objTable.FullTextCatalogName = "ftcPubsTest"
objTable.UniqueIndexForFullText = "UPKCL_auidind"
objTable.FullTextIndex = True

'Specifies the indexed column
objTable.Columns("au_lname").FullTextIndex = True
objTable.Columns("au_fname").FullTextIndex = True

'Activate the full text index on this table
objTable.FullTextIndexActive = True

step5. Start the full text catalog
objCatalog.Start SQLDMOFullText_Full
Use stored procedure
step1. Make pubs Database for full text search
USE Pubs
go
sp_fulltext_database 'enable'

step2. Create a new catalog
sp_fulltext_catalog 'ftcPubsTest','create'
step3. Specify the table to be indexed
sp_fulltext_table 'authors','create','ftcPubsTest','UPKCL_auidind'
step4. Specify the column to be indexed
sp_fulltext_column 'authors','au_lname','add'
sp_fulltext_column 'authors','au_fname','add'
step5. Activate the full text index on this table
sp_fulltext_table 'authors','activate'
step6. Activate the full text catalog
sp_fulltext_catalog 'ftcPubsTest','start_full'

The above is the content of full text retrieval application (1). For more related articles, please pay attention to the PHP Chinese website (m.sbmmt.com)!