containstable

My ContainsTable query is not working - please help :)

Hi folks, I've got a full text catalogue setup. It has a unique key count of 117 with 19 items. The table has 19 rows only. The table has an NVARCHAR(50) field called ClientGuid. It's a guid with some weird text at the end. eg.. 8b6ef4a504dd1a57f079180e7f6eb4a0(-) 8b6ef4a504dd1a57f079180e7f6eb4a0(OK) (and no, i didn't defined th...

How to weight in full-text search

I want to search on a phrase, for example "search preference". I want to return the phrase itself as most heavily weighted. Next I would want to return "search" and/or "preference". And, in lowest ranking, I would want "searching" or "searches" or "preferences". I don't know what to put for weights in the IsAbout. 'ISABOUT( "search prefe...

SQL Server Full Text ContainsTable function Rank issue

Is is possible to increase the Rank of the ContainsTable results if its an Exact match. I have a fulltext query like this select iname,rank from ItemSearch_View sv INNER JOIN CONTAINSTABLE(ItemSearch_View,searchstring, '(FORMSOF(INFLECTIONAL, "google") )',500) AS itable ON sv.itemid = itable.[KEY] order by rank desc which provides ...

SQL Server 2008 CTE And CONTAINSTABLE Statement - Why the error?

I am testing out moving our database from SQL Server 2005 to 2008. We use CTE's for paging. When using full-text CONTAINSTABLE, the CTE will not run and generates an error. Here's my non-working code- WITH results AS ( SELECT ROW_NUMBER() over (ORDER BY GBU.CreateDate DESC ) as rowNum, GBU.UserID, NULL AS DistanceInMi...

are there any special conditions with '*' character in full text search

i am using sql server 2005 i have a stored procedure which searches database with containstable method the problem is when i search some prefix with '*' character i can't see the records which have full word just records with only prefixes. for example i search 'some' then set my variable to 'some*' and i have 'some' and 'something' reco...

AND statement for multiple columns in fulltext index

I have a fulltext indexed table and try to query for results matching multiple words. E.g. I have a address table with the indexed columns address_text, zip_code and city. | ROW | address_text | zip_code | city | | 1 | Bourbon street | 1234 | Baltimore | | 2 | Bourbon street | 1234 | New Orleans| Now I want t...

Is it possible to use ContainsTable to get results for more than one column?

Consider the following table: People FirstName nvarchar(50) LastName nvarchar(50) Let's assume for the moment that this table has a full-text index on it for both columns. Let's suppose that I wanted to find all of the people named "John Smith" in this table. The following query seems like a perfectly rational way to accomplish thi...

Escape ContainsTable Keywords

How can I escape ContainsTable control keywords (such as NEAR or ISABOUT) so that Full Text Search will actually look for those words, and not treat them as control keywords? ...

CONTAINSTABLE with wildcard works different in SQL Server 2005 and SQL Server 2008?

I have two same databases one on SQL Server 2005 and one on SQL Server 2008, it have same SQL_Latin1_General_CP1_CI_AS Collation, and full text search catalogs have the same settings. These two databases contains table with same data, NTEXT string: "...kræve en forklaring fra miljøminister Connie Hedegaard.." My problem is: CONTAINST...

CONTAINSTABLE query not recognising small words

I'm using CONTAINSTABLE to search two table columns. Once the search contains small words like 'the' 'for' 'a' the search returns no results even when they are actually present in the column. Quick example. Column being searched contains the text. 'System needs to be upgraded' Following SQL returns 0 rows SELECT * FROM Incident WH...