September 12, 2005 at 6:27 pm
How do I set up full text search on related tables? I have an Issue table and a Resolution table which has an IssueId as a foreign key. I need to be able to search issues and resolutions for search phrases. This is my first delv into FTS and any pointers would be appreciated.
September 13, 2005 at 8:09 am
Mark,
There are a couple ways of doing using SQL Full-Text Search (SQL FTS) to search across mutiple tables using either CONTAINSTABLE or FREETEXTTABLE, below is a blog entry that covers these methods:
SQL Server FTS across multiple tables or columns
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!316.entry
FYI, for SQL Server 2000 Full-Text Search Resources and Links
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!305.entry
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
John T. Kane
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply