Stack Overflow
Stack Overflow

Questions tagged [freetexttable]

Is a function used in the FROM clause of a Transact-SQL SELECT statement to perform a SQL Server full-text search on full-text indexed columns containing character-based data types.

Is a function used in the FROM clause of a Transact-SQL SELECT statement to perform a SQL Server full-text search on full-text indexed columns containing character-based data types. This function returns a table of zero, one, or more rows for those columns containing values that match the meaning and not just the exact wording, of the text in the specified freetext_string. FREETEXTTABLE is referenced as if it were a regular table name.

43 questions
0
votes
1 answer

Sql FREETEXTTABLE with list searchkey

it looks FREETEXTTABLE just allow searchkey parameter as variable, like this: FROM FREETEXTTABLE(dbo.SampleTable, SampleColumn, @searchKey) I have a list searchKey values, about 50000 records, how to "JOIN" searchKey table with FREETEXTTABLE I've…
minhhungit
  • 180
  • 4
  • 25
0
votes
0 answers

Searching Database with partial keyword

I'm trying to do a search of all the columns of a specific table and I want to return the result that contains certain characters. For example Entered Search Value: "Josh" Output Values: Josh, Joshua, Joshie, Rich Joshua I want to return all values…
Rich
  • 3,928
  • 4
  • 37
  • 66
0
votes
1 answer

FreeTextTable returns no records

I have a flat table to perform Full Text Search and even the simplest search doesn't work. I have tried numerous things and I am getting same result. However surprising thing is that similar Full Text Search works on other tables in the same…
ndd
  • 3,051
  • 4
  • 25
  • 40
0
votes
3 answers

Handling empty space in reading table from text file python

I need parse file as where this link is given below. http://bit.ly/1x6yzoX I wrote this fallowing method to parse this file, but unable to read incomplete data of latest year(2014) which empty spaces in table of text file. For now I am skipping the…
Sreedhar
  • 367
  • 1
  • 3
  • 8
0
votes
1 answer

iFTS Free-Text SQL Server 2014 multiple columns multiples keywords

I am starting with FTS, and I just got stuck on a problem. When I try to search on my table using a Containstable, I cannot figure out how to make it search on every columns. It returns 0 element even if I know someone exists with this name.…
Lenny32
  • 624
  • 6
  • 15
0
votes
1 answer

Full-text Search Using Freetexttable Failing on Noise Words - SQL Server 2008 R2 Transform Noise Words not working

I am running a full-text search for my site using SQL Server 2008 R2 and freetexttable. I am getting this error when a stop word is entered: Informational: The full-text search condition contained noise word(s). So I did what everyone said to do…
jnl
  • 447
  • 4
  • 7
0
votes
1 answer

MS SQL SERVER FTS FREETEXTTABLE search by part of word

I use FTS and it returns for query "Møreforsking" results contains "Møre" as a separate word. I understand that "Møre" and "forsking" are different words and can be use separatly. How can I avoid the problem? I want to search only for whole word…
BotanMan
  • 1,357
  • 12
  • 25
0
votes
1 answer

python : colspan in texttable

table = Texttable() table.set_deco(Texttable.HEADER | Texttable.VLINES | Texttable.HLINES | Texttable.BORDER) table.add_rows([ ["Name", "Age", "Nickname"], ["Xavier Huon", 32, "Xav'"], ["Baptiste Clement",…
Robby Zhi
  • 29
  • 2
0
votes
1 answer

Cannot find my search "iso" in a word "TESTISOTEST" by using FREETEXTTABLE

First, i'm starting to implement a fulltext search on a table of 12 millions of rows. So maybe I have not yet understood all of its intricacies. :) All those 12 millions of rows seem to indexed correctly and my index is correctly created with 1036…
Sébastien.B
  • 31
  • 3
0
votes
3 answers

Why is Select distinct from function returning duplicates?

I tried two different variations on the same thing. The first version selects from freetexttable, the other insets into a temp table and selects from that. I've tried numerous variations on the first version (select several combinations, at both…
Brian
  • 25,523
  • 18
  • 82
  • 173
0
votes
1 answer

Handle Search Result relevance from multi Table using FREETEXTTABLE

I'm developing an application which allows the user to find Product references, searching by keywords (Using the FREETEXTTABLE feature of full-text indexed Table for SQL 2008). Those reference are extracted from two different databases that are both…
WizLiz
  • 2,068
  • 5
  • 25
  • 39
0
votes
1 answer

Term order in FREETEXTTABLE in SQL Server

From the documentation, it seems that SQL Server's FREETEXTTABLE should treat a search query containing multiple words as a bag-of-words. If I run: SELECT * FROM FREETEXTTABLE(tblThings, *, 'Cartridge Black') I get results where the word…
Paul
  • 16,285
  • 13
  • 41
  • 52
0
votes
1 answer

Do MS SQL Server 2000 full text index queries using freetextable use stemming?

I'm using MSSQL's full text indexing on a handful of tables in my CMS and am unfortunately stuck with SQL Server 2000. I'm querying the index using freetexttable joins and am having pretty good results, but we have some unique terms that are likely…
cori
  • 8,666
  • 7
  • 45
  • 81
1 2
3