I have a full-text index created upon a column of type varchar(max) with filestream enabled. The filestream contains data such as JPG's, TIF's, PDF's, and XML's (although this is mostly irrelevant to the question, I believe).
I have two queries that I've created that allow me to search upon the index.
Full-text search #1--
Full-text search #2--
The only significant difference between the two full-text searches is query #1 uses contains and query #2 uses containstable.
My problem is that the two queries do not always yield the same results. For example, were I to search on the phrase "Independent contractors", query #1 would yield a result set of 10 different documents (PDF's and XML's), while query #2 would only yield a result set of 6. This seems to be the rule: query #1 always yields a few more than query #2, and query #2 always yields the exact same matches that query #1 does.
Query #1 - search on "Independent contractors" yields:
Query #2 - search on "Independent contractors" yields:
Thanks for any help that I receive on this!!
asked Nov 17 '10 at 10:45 AM in Default
Jagd - from reading the information in [BOL] I understand the main difference between
I would imagine that is what you are seeing, as
I think the explanation in BOL above is quite clear.
HTH: h ttp://technet.microsoft.com/en-us/library/ms187787.aspx
answered Nov 17 '10 at 11:19 AM