Basic knowledge
1. There is no full-text search in the DeskTop version of SQL Server7.
2. A table can have only one full-text search.
3. The retrieved table must have a unique index of a single column.
4. The index of the full text is stored in the file system, not in the database.
5. The process of updating a full-text index is time-consuming than a regular index and is not immediately updated by the database system, as is the case with regular indexes.
6. Full-text indexes are included in the full-text catalog (Full-text catalog), where each database can contain one or more directories, but one directory cannot belong to more than one database.
7. Full-text retrieval can only be created on real tables, not views, system tables, temporary tables.
8. Full-text search ignores certain noise words (noise words), such as English A,the,and, Chinese ' and ', ' yes ' and so on.
9. If noise words is included in the query, an error is raised and these noise words should be removed from the application.
Start the full text Search service.
Method A: Open the Support Services folder in Enterprise Manager and select Start in the right-click menu of Full-text Search.
Method B: Select Microsoft Search from the SQL Server Service Manager Services drop-down list and click the Start/continue button.
Method C: Use the net start MSSearch command line method.
Use the Full Text Search wizard (Full-text indexing).
Step1. Select the retrieved database, in the Tools menu, select Full-text indexing, enter the Welcome (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 column to be indexed, click Add, and the column appears in the right column. Click Next.
Step5. Select the directory (select an existing directory, or create a new directory) and click Next.
Step6. Select or create population schedule (optional) and click Next.
Step7. Click Finish.
Using SQL-DMO (take VB for example)
Step1. Select the Microsoft SQLDMO Object Library in the project reference.
Step2. Creates a SQL Server object.
Dim Objsql as New SQLDMO. Sql server
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 a full-text searchable database
Objsql.databases ("pubs"). EnableFullTextCatalogs
' Create a new directory
Objcatalog.name = "Ftcpubstest"
' Add a new directory to the catalog collection
Objsql.databases ("pubs"). Fulltextcatalogs.add Objcatalog
http://www.bkjia.com/PHPjc/631221.html www.bkjia.com true http://www.bkjia.com/PHPjc/631221.html techarticle basic knowledge 1. There is no full text search in the DeskTop version of SQL Server7. 2. A table can have only one full-text search. 3. The retrieved table must have a unique index of a single column. 4. The full text of the ...
