Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

using rank in fulltext

 
   Database Help (Home) -> Full Text RSS
Next:  SSIS 2008 and MOSS 2007  
Author Message
Roy Goldhammer

External


Since: Mar 06, 2008
Posts: 47



(Msg. 1) Posted: Thu Aug 28, 2008 10:56 am
Post subject: using rank in fulltext
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)

Hello there.

I'm new on FullText Search.

I need this in order to find part of words on 3 of my columns in table
(Table1(Txt1, Txt2, Txt3)

I've discovered the function CONTAINSTABLE(...) which brings me rank of
find.

what is the logical of ranks?

 >> Stay informed about: using rank in fulltext 
Back to top
Login to vote
Russell Fields

External


Since: Aug 28, 2008
Posts: 4



(Msg. 2) Posted: Thu Aug 28, 2008 4:13 pm
Post subject: Re: using rank in fulltext [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Roy,

Perhaps this is what you are looking for:
http://technet.microsoft.com/en-us/library/ms142524.aspx

RLF

"Roy Goldhammer" wrote in message

> Hello there.
>
> I'm new on FullText Search.
>
> I need this in order to find part of words on 3 of my columns in table
> (Table1(Txt1, Txt2, Txt3)
>
> I've discovered the function CONTAINSTABLE(...) which brings me rank of
> find.
>
> what is the logical of ranks?
>

 >> Stay informed about: using rank in fulltext 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Number of documents vs rank in FTS - Dear all, I am interested in using FTS for scientific investigation. Specifically, I need to know exactly how often certain keywords occur in documents in my collection. I know how many documents contain the keyword, but how do I find out how often the....

Incorrect RANK results returned - Morning all, I'm having problems with my FTS rankings on our SQL2005 database and I'm a bit stumped as where to start looking at what the the problem might be. The simplified SQL is as follows:..

fulltext search not working - HI!, Fulltext search is not working, i have two databases, fulltext search functionality was working fine on both of them till now. but suddenly fulltext search on one of the databases started giving out errors. when i try to populate, rebuild was..

Smae Fulltext index name in two DBs on same machine - Hiya All, We run a Developmnet-> Staging -> Production build environment here. We use Red Gate SQL Compare (a REALLY great bit of kit btw) to move between the tiers. We are having a bit of a problem now that we have some fulltext indexes defined....

Fulltext Indexing leaves a transaction open, preventing in.. - Hello, Please read this two threads first, as this all started on .newusers (I'm one of them) More relevant: (http://tinyurl.com/454uav http://preview.tinyurl.com/454uav)..
   Database Help (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]