2012年3月21日星期三

full text search

how do i prepare a db for a full text search on a table? are there any
special procedures or tutorials on this? i have an article db which i need
to do a full text search with boolean operators on a articlecontents field..
ive never programmed a full text search before, so any help is welcome,
thanks!Brian,
The best place to look for introduction information on SQL Server (7.0 or
2000) Full-Text Search (FTS) components is the BOL. Use the search tab and
search for "full text" (use the double quotes) as this will point you to the
titles "Full-Text Query Architecture" among others.
You can use the "Full-text Indexing" Wizard via the Query Analyzer or
Enterprise Manager as well as right-click on a table in the EM and select
Full-text Index and this will launch the FT Wizard as well as FT-enable the
database (use sp_fulltext_database behind the scenes). Once you've got the
FT Index created and populated you can query it with either CONTAINS or
FREETEXT (both are documented in the BOL)
Also a good source of SQL FTS related questions can be posted to the
newsgroup: microsoft.public.sqlserver.fulltext
Regards,
John
"Brian Henry" <brianiup@.adelphia.net> wrote in message
news:OwqjUOnjDHA.2964@.tk2msftngp13.phx.gbl...
> how do i prepare a db for a full text search on a table? are there any
> special procedures or tutorials on this? i have an article db which i need
> to do a full text search with boolean operators on a articlecontents
field..
> ive never programmed a full text search before, so any help is welcome,
> thanks!
>sql

没有评论:

发表评论