C# Programming
06-29-2009, 07:00 PM
i am using ms sql server 2005. i used full text search (fts) facility. now i want to know that does fts cares about sequence of a phrase. for example
("select * from news AS N INNER JOIN containstable(news,datacontent,'local' AND 'company') AS A ON N.[id]=A.[KEY] ORDER BY A.RANK DESC",connec)
this returns results that includes local and company but anywhere in the document. but i want it like "my local company is very big." so i mean the word "company" must come after "local" (at least 1 time) to have a result. how can i do this. i tried it as 'local company' but an error occured.
("select * from news AS N INNER JOIN containstable(news,datacontent,'local' AND 'company') AS A ON N.[id]=A.[KEY] ORDER BY A.RANK DESC",connec)
this returns results that includes local and company but anywhere in the document. but i want it like "my local company is very big." so i mean the word "company" must come after "local" (at least 1 time) to have a result. how can i do this. i tried it as 'local company' but an error occured.