Application of full text search. Basic knowledge 1. SQL Server 7 DeskTop edition does not have full text retrieval. 2. a table can only have one full text search. 3. the retrieved table must have a unique index for a single column. 4. basic knowledge of full text
1. SQL Server 7 DeskTop edition does not have full text retrieval.
2. a table can only have one full text search.
3. the retrieved table must have a unique index for a single column.
4. full text indexes are stored in the file system rather than in the database.
5. the process of updating a full text index is more time-consuming than that of a regular index, and can be updated immediately by the database system as a regular index.
6. Full Text indexes are included in the Full-Text Catalog. each database can contain one or more directories, but one directory cannot belong to multiple databases.
7. full text search can only be created on a real table, not a view, system table, or temporary table.
8. some noise words will be ignored in full text search, such as English a, the, and, Chinese 'and', and 'Yes.
9. if the query contains noise words, an error will be thrown, and these noise words should be removed in the application.
Start the full text search service.
Method A: Open the Support Services folder in the enterprise manager and select Start from the context menu of Full-Text Search.
Method B: select Microsoft Search from the Services drop-down list of SQL Server Service Manager and click Start/Continue.
Method C: use the net start mssearch command line.
Use the Full-Text Indexing Wizard ).
Step 1. select the database to be retrieved. in the Tools menu, select Full-text Indexing to go to the Welcome screen and click next.
Step2. select the table to be retrieved and click next.
Step3. select a unique index and click next.
Step 4. select the indexed column and click Add. the column is displayed in the right column. Click next.
Step 5. select a directory (select an existing directory or create a new directory) and click next.
Step 6. select or create population schedule (optional) and click next.
Step7. click finish.
Using SQL-DMO (using VB as an example)
Step 1. select Microsoft SQLDMO Object Library from the project reference.
Step 2: Create an SQLServer object.
Dim objSQL As New SQLDMO. SQLServer
ObjSQL. Connect "localhost", "sa ",""
Step create a new directory and add it to the database directory to be indexed.
Dim objCatalog As New SQLDMO. FullTextCatalog
'Make pubs the database for full text search
ObjSQL. Databases ("pubs"). EnableFullTextCatalogs
'Create a new directory
ObjCatalog. Name = "ftcPubsTest"
'Add the new directory to the directory set
ObjSQL. Databases ("pubs"). FullTextCatalogs. Add objCatalog
Partition 1. the SQL Server 7 DeskTop version does not have full text retrieval. 2. a table can only have one full text search. 3. the retrieved table must have a unique index for a single column. 4. full text...
