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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Effective method of search from SQL Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-31 : 09:16:23
Smitha writes "Hello Sql Team

I have a requirement where I have to store contents of a text file (of approximate size 16k to 30k) as one of the columns of a table. When the user from the front end specifies a keyword and requests a search, I have to search the contents of the text file for the keywords. Assuming that I may have a minimum of 10,000 rows each containing a text file in a column, what would you say is the best search methodology.

Regards
Smitha"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-05-31 : 09:16:23
First, I'd learn about full-text indexing: http://www.sqlteam.com/FilterTopics.asp?TopicID=118

If that doesn't work you can read about how I do searching here on SQLTeam.com: http://www.sqlteam.com/item.asp?ItemID=1876
Go to Top of Page
   

- Advertisement -