Re: newbie: containstable query structure
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Tue, 5 Sep 2006 08:31:39 -0400
Only product_name, if you specify * for the columns to search it will search
all full-text indexed columns.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"geek-y-guy" <noone@xxxxxxxxxxx> wrote in message
news:%23o7kKq5yGHA.4648@xxxxxxxxxxxxxxxxxxxxxxx
Hi: Quick question...I have a FT catalog populated with a table of
products. The catalog contains the product_id, product_name, and
product_description fields.
When I write a query, like:
select p.*, k.rank from products p inner join
containstable(products,product_name,'isabout (firestone weight(.9),tire
weight (.1))') as k
on p.p_id = k.[key]
order by k.rank desc
does the search only occur on the "product_name" field, or does it search
all 3 fields in the catalog?
.
- Prev by Date: Re: Containstable weighting question
- Next by Date: Re: Full text catalog on multiple tables
- Previous by thread: Re: SQL FT Catalog not populated
- Next by thread: Performance issue with CONTAINS
- Index(es):
Relevant Pages
|
Loading
