Questions on SQL Server 2008 Full-Text Search
Posted
by Eddie
on Stack Overflow
See other posts from Stack Overflow
or by Eddie
Published on 2010-03-22T01:33:17Z
Indexed on
2010/03/22
1:41 UTC
Read the original article
Hit count: 350
sql-server-2008
|full-text-search
I have some questions about SQL 2K8 integrated full-text search.
Say I have the following tables:
- Car with columns: id (int - pk), makeid (fk), description (nvarchar), year (int), features (int - bitwise value - 32 features only)
- CarMake with columns: id (int - pk), mfgname (nvarchar)
- CarFeatures with columns: id (int - 1, 2, 4, 8, etc.), featurename (nvarchar)
If someone searches "red honda civic 2002 4 doors", how would I parse the input string so that I could also search in the "CarMake" and "CarFeatures" tables?
© Stack Overflow or respective owner