text
Tue, 23 Sep 2008 07:35:02 +0800
text
...
|
text
Tue, 23 Sep 2008 07:34:42 +0800
text
...
|
@SearchConditions FREETEXTSEARCH CONTAINSTABLE
Thu, 18 Sep 2008 16:27:29 +0200
I have a situation like this
TAble1
ID Title
UsersCount
1 "the da vinci code"
10
2 "The Da Vinci Code and the Secrets of the Temple" 5
3 "The Da Vinci Code Decoded"
2
I want to have a search that when I search for 'the da vinci code' rank the
results as
1,3,2 ...
|
Special Characters in Search
Mon, 8 Sep 2008 14:32:19 +0200
This has propably been asked before - sorry.
Our Users would like to search for Strings that contain special characters
and I need to figure out a way to do this with SQL Server 2005 full-text
search (example would be 'Job#$23#3'). After searching the net I couldn´t
really come up with a sufficient answer t ...
|
Question about Freetexttable
Wed, 3 Sep 2008 08:33:39 -0400
If I have a FT Index with a varchar field, and there are two rows:
1234
1234AV
If I run a freetexttable query against that index searching for '1234', why
does it only return the first row and not the second? Is there any way to
get it to return both rows, or would I have to use containstable with a
wil ...
|
question about freetexttable matching
Tue, 2 Sep 2008 17:24:37 -0400
I have a full text cat for "products" set up against a table with product
information such as product-ID, product-name, product-description, all of
which are in the view. All the fields are varchars.
I have two similar products with similar product-IDs, like:
1234
1234XL
If I perform a freetexttable qu ...
|
SQL full text catalog problem
Mon, 1 Sep 2008 12:59:52 +0300
hello to everyone ,
We have in our company a two nodes active-passive cluster with SQL Server
2000 SP4.
Recently one of our customer required from us to create a full text
catalog for some tables & columns
for his database.
So we made it ,but we realise that Microsoft Search didn't work when w ...
|
|
|
Need help with sqlserver search stored procedure.
Fri, 29 Aug 2008 09:14:32 -0700 (PDT)
HI,
I am writing a stored procedure for my search box control. I found
this sample code which sets the @WORD1 to 'TBB-12' and searches 1
table for the information. I set the value to TBB-12 and specified to
look in the dbo.product_id. It did find the product id = TBB-12 on the
first result row, however, it r ...
|
using rank in fulltext
Thu, 28 Aug 2008 10:56:09 +0300
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?
...
|
hyphen as word-breaker
Wed, 20 Aug 2008 12:03:27 -0500
Hello All,
I have a sql server 2005 db which contains a full text catalog on a
table, certain columns on that table have a words with hyphens in them,
the customer expects the results to come up when the search term
contains hyphens, but looks like the indexing service uses hyphens as
word breakers a ...
|
