Use full-text retrieval of SQL Server 2000

UseSQL Server 2000The full-text retrieval function of is selected from lihonggen0's blog

Steps:

1, Open Northwind Database, right-click Products Table, select full-text index table, and define full-text index on the table to create a full-text directory for it. In the "full-text index wizard", select the columns (text or images) for which you need full-text query conditions. Productname And Quantityperunit Column. Next, enter a new directory. Procatalog And click Next. In the filling scheduling item, we do not set up filling scheduling for the moment. Next, complete the full-text index wizard. After that, we can see that there is an additional full-text directory in the full-text directory. Procatalog . Right-click Procatalog Attribute to view its status, table, and scheduling.

 

2, Right-click the full-text directory Procatalog , "Start full fill", the system will see "Full Text directory filling started successfully ".

 

3, In this case, we can use Transact-SQL For full-text search, we use Contains , Freetext . For example:

 

Search Productname Contains B Include C All columns

Select *

From Products

Where contains (productname, '"C *" and "B *"')

 

SearchProductnameContainsChai Chang tofuAll columns of one

Select *

From Products

Where freetext (productname, 'chai Chang tofu ')

 

We can also useContainstable,FreetextTableAnd so on

 

4, We can use . Net Create Web Or Form The client provides a good full-text Retrieval Interface for your applicationsProgramGet extended