2012年3月25日星期日

Full text search in SQL Server 2000

I have one question about full text search in SQl
Server 2000/2005.
I have one table which has 7 text columns. I want to
retrieve all rows that have the search word in either
of those 7 columns.
I want to know if there is a way to add weight to
those columns so SQL Server can better rank the result
set. For example, column 1 has weight 1 and column 2
has weight 0.1. So records that have search word in
column 1 will rank higher that those having search
word only in column 2.

Thanks a lot,

Baoxin

Unfortunately, There is no standard way to do this.
You can have to play around with regular expressions..

没有评论:

发表评论