August 13, 2008 at 3:41 am
We need to write a stored procedure which works like a search engine.
The data has to be fetched from multiple tables.
Search on a keyword should return
1. Exact Search against a column.
2. Split the Keywords and search against each word (AND)
2. Split the Keywords and search against each word (OR)
What would be the best approach?
Let me know if I have to elaborate further....
August 13, 2008 at 5:06 am
Can you put your table definitions, or at least, the columns needed?.
Can you give us some examples of data in the tables and the results expected?
August 13, 2008 at 6:53 am
rosh (8/13/2008)
We need to write a stored procedure which works like a search engine.
Have you considered using FullText Search? This isn't an area that the relational engine excels in.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply