Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jon G
Starting Member
31 Posts |
 Posted - 2007-03-10 : 09:30:29
|
| Example:I have 1,000 text files, each contains approx 1,000 words.I have a record within my database for each of the 1,000 files, and then a path statement to the files. My application searches the database for a particular text file title (stored in a field in the database) and brings back the results of all text files that contain that word in the title. This all works fine.However, how would I go about adding the full text of each text document to my database in order to do a full text search on each of the documents. What field type should I use to hold the text of each text file?Or, am I going about this all wrong?Jon |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-14 : 14:08:00
|
| Too complicated to write it all here, but use BOL to set up FULL Text Indexing and then write queries using CONTAINS or FREETEXT to query the Full Text portions of your database.BOL: How to enable a table for full-text indexing (Enterprise Manager)BOL: CONTAINSRaymond LaubertMCDBA, MCITP:Administration, MCT |
 |
|
|
|
|
|
Full Text indexing of text files