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
1
vote
1 answer

SQl server search, using FREETEXTTABLE (Transact-SQL)

Thanks in Advance. I am implementing FREETEXTTABLE into a search form. I wanted to know how the following queries would behave and what results would be returned. Also, would like to know if brackets form a valid part of a query. So, if I search for…
jamesmhaley
  • 44,484
  • 11
  • 36
  • 49
1
vote
1 answer

Searching numeric strings with Full-Text Search in SQL 2005

I'm using the SQL Full-Text Search and have a stored proceedure that uses the FREETEXTTABLE function. This all works great, however, I have noticed that if I search for something such as 'Chapter 19' the 19 seems as if it is thrown away and the…
Jamie
  • 988
  • 1
  • 11
  • 19
1
vote
0 answers

SQL Server freetexttable special characters

When I use FreeTextTable in SQL Server and pass search key with a special character like hyphen, it looks for all results matching for keyword partone or keyword parttwo. How can I restrict it doing that and search for partone=parttwo as one word?…
HaBo
  • 13,999
  • 36
  • 114
  • 206
1
vote
2 answers

Create FREETEXTTABLE in MS SQL

I am trying to create FREETEXTTABLE. I am getting this following error. Msg 7601, Level 16, State 2, Line 1 Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Flags' because it is not full-text indexed. My Sample, CREATE TABLE…
KarthiK
  • 13
  • 5
1
vote
0 answers

SQL Server FREETEXTTABLE minimum length

I'm getting no results when using a FREETEXTTABLE query when my search string is only 3 characters in length (when its 4 it returns results). Below is the code I'm running when it returns results, but if I change my search term to 'gol' it returns…
R Grove
  • 31
  • 4
1
vote
3 answers

how to install texttable in python

My code is: import texttable as tt tab = tt.TextTable() header = ['Manager', 'Club', 'Year'] tab.header(header) print tab.draw() During execution the following error occurs. ImportError: No module named texttable Can anyone help me with…
user3251664
  • 441
  • 2
  • 7
  • 11
1
vote
2 answers

Full text searching scores across multiple columns

I am using full text searching on a SQL Server database to return results from multiple tables. The simplest situation would be searching a persons name fields and a description field. The code I use to do this looks like: select t.ProjectID as…
Matthew
  • 9,851
  • 4
  • 46
  • 77
1
vote
0 answers

Combine two queries and also weight to a column using FREETEXTTABLE?

I have these two queries that give me what I want: 1) SELECT sr.ServicesResourcesID AS ID, sr.Title, sr.ContactFirstName, sr.ContactLastName, sr.ContactEmail, sr.ContactPhone, sr.FileName, sr.URL, sr.Description AS Description, rt.Type,…
M Holland
  • 11
  • 1
1
vote
2 answers

Ordering FREETEXTTABLE result UNIONed with standard SELECT by Rank

I had a working FREETEXTTABLE query that searched for a @searchString. I now need to UNION that with another simple query that tries to parse the @searchString into an INT, and if it succeeds, filtering the table by looking for the row with PK equal…
Brandon
  • 13
  • 4
1
vote
1 answer

FreeTextTable filter search string

I am joining onto a freetexttable using a searchTerm parameter which is also used in a number of other freetexttables in the query. I would like to remove the city name from this parameter if it exists in the current row. Trying to use replace like…
Luke Lowrey
  • 3,203
  • 3
  • 28
  • 40
0
votes
1 answer

When using FREETEXTTABLE in ms sql server how do you search on the primary key?

I have a query using a FREETEXTTABLE full text search which works perfectly for every column included in the index except for the primary key. The primary keys are in a format like abcdef123456 and when you search for abcdef123456 you get that one…
jellomonkey
  • 1,954
  • 15
  • 15
0
votes
1 answer

Can't join FREETEXTTABLE with typeORM functions

I'm working on a graphQL backend with TypeORM I found FREETEXT, CONTAiNS, FREETEXTTABLE and CONTAINSTABLE options for fulltext searching in my SQL database. As FREETEXTTABLE has a "RANK column, it is more useful and I’m using this option. I added…
Fahima Farrahi
  • 13
  • 4
0
votes
1 answer

Typeorm of sql query

This query works well on the database, however I'm not able to make it work by using typeorm createQueryBuilder. SELECT * FROM content INNER JOIN FreeTextTable(content, *, 'text') AS KEY_TBL ON content.id = KEY_TBL.[KEY] ORDER BY KEY_TBL.RANK…
Sina Hosseini
  • 36
  • 3
0
votes
1 answer

SQL Server 2005 - FREETEXTTABLE ignoring single characters

I have an issue with a query I'm running. Basically it's a search on a table of books. This query below uses the FREETEXTTABLE command to rank the search for an author: @author = 'lewis c s' SELECT * FROM tbl_products INNER JOIN…
Darthtong
  • 1,017
  • 4
  • 18
  • 30
0
votes
1 answer

SQL Server FTS indexing correct keywords but not returning results with those keywords

I've created a FTS catalog which indexes the Title column of a table called Articles. The word breaker language is set to Dutch. The article title is "Contactgegevens Wijkteams 2019". My search term is 'contactgegevens' which is Dutch for 'Contact…
Jacques
  • 6,936
  • 8
  • 43
  • 102
1
2
3