All Questions
Tagged with full-text-search sql-server-2008
292 questions
0
votes
1
answer
138
views
Email ID filter using freetext sql server
I cannot able to filter email from table using 'freetext' in sql server.
For ex:
select *
from abc
where column = '[email protected]'
is getting all data having @ and .com think so.
6
votes
2
answers
1k
views
Full-text Index stop list for Persian language
I need to customize Full-text search for Persian language. And customize Stop/Noise words and synonyms for this language.
My SQL Server version is 2016 and full-text search is installed.
- 99
4
votes
1
answer
744
views
Does dropping of non clustered index removes existing Full Text Indexing in SQL Server table?
CREATE TABLE [dbo].[TicketTasks]
(
[TicketTaskId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[TicketTaskTypeId] [char](2) NOT NULL,
[TicketId] [int] NOT NULL,
[...
- 395
1
vote
1
answer
2k
views
How can i use full text index to find records which begin with a specific character or word?
I have the following query with LIKE condition:
Select top 20 * from entity with(NOLOCK) where first like 'john%'
The Above query will return the employee whose first name starts with John.
Now the ...
- 35
1
vote
0
answers
51
views
FullText Index first Match position
I want to do FulltextSearch columns in a table to find CompanyInfo that use keyword "Internet Of things" and at what position in Company Description is this word found.
Company table has ID, ...
- 1,353
0
votes
0
answers
400
views
Creating a full text search on xml column
I searched much in internet about "Creating a full text search on xml column". I found this link but this link does not work.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=113478
EDITED:
create ...
- 297
2
votes
0
answers
153
views
SQL Server Thesaurus XML File
Is there somewhere I can get the xml thesaurus file such as english, french, russian, polish and italian from the web (for SQL Server that is)?
3
votes
1
answer
302
views
Sql Full-Text Query Expression, How to know which forms of synonyms match by sql?
I am using Sql Full-Text Query expression to find out the inflectional word from given table.
My sql query are look like
select * from Production.Product where CONTAINS(*,'FORMSOF(inflectional,"...
- 355
0
votes
1
answer
1k
views
Syntax error on full text search
I am trying to do a search where the data can match any set of columns.
When I run this
DECLARE @Name varchar(80) = 'wisr aaron'
SELECT ID FROM Data WITH (NOLOCK) WHERE CONTAINS(*, @Name)
...
- 11.1k
1
vote
2
answers
82
views
Can I use full text search a row in a table where the condition is an array of values from a select query?
I want to create a view and I want to do a full text search of a row using a set of keywords. These keywords exist in a table in the database.
So is it possible to do something like below where I can ...
- 18.8k
0
votes
0
answers
132
views
Full text search constain multiple criteria
I'm using full text search with SQL Server 2008. I want to search in 2 columns with different criteria.
Example:
column name : contains(name,'"ma*"')
column address : contains (address, 'tr')
When ...
0
votes
0
answers
180
views
Error 948 on sql server 2008 when trying to attach semanticsDB
When i'm trying to attach semanticsDB, it says that the database semanticsdb is version 693 but mine is 661.
Is there a way to run the semantic search (https://msdn.microsoft.com/en-us/library/...
- 673
0
votes
0
answers
71
views
SQL Server full text search not returning correct number rows
I have strange problem. Table has a computed column with full text search in this column.
When I using query:
SELECT *
FROM Table
WHERE CONTAINS (ComputedColumn, 'David')
2 rows returned.
...
- 87
0
votes
1
answer
477
views
SQL Server 2008 missing thesaurus xml and ftdata folder
I've recently installed SQL Server 2008, and I've tried the full text search and now I need to use the thesaurus for synonymous but I can't find any xmq and the ftdata folder which I read should ...
- 673
0
votes
1
answer
670
views
Syntax error trying to see sys.dm_fts_index_keywords
Trying to run
SELECT *
FROM sys.dm_fts_index_keywords( DB_ID('database_name'), OBJECT_ID('table_name') )
against the table with the index and I get a syntax error
If I run in on master I get
...
- 135
0
votes
0
answers
26
views
SQL Server 2008 Full text search stopwords
I have row values like "shop.it", "shop.com" for a column
When I do full text search by shop, I can get "shop.com" but not "shop.it".
I am using SQL Server 2008.
Please help me on the same
- 1
0
votes
1
answer
419
views
SQL freetext() not working on some columns
I have a table which contains 7 columns and I have created a full text index on the table. However I noticed that a search using freetext() does not return any rows on 2 of the columns
Its returns ...
1
vote
0
answers
448
views
How can I customize fulltext search without sys.dm_fts_parser
What I want to be able to do is send a query into a full-text search that returns only the results that match ALL words. The default implementation of full-text search seems to match ANY words in the ...
- 727
1
vote
0
answers
120
views
Restricting SQL full text search to beginning of text or determining word position
I'm using full text search in SQL Server 2008 R2 and it works well. I have a new requirement where I need to be able to search just the first 100 words or so of an nvarchar(max) column that is part of ...
- 726
1
vote
1
answer
65
views
Is there a way to select a document that contains a word not followed by a particular word in full text?
I have a table named Documents that has Content field full text indexed
Now i need to create a query in such a way that the query should return docs that have at least one word "hello" that does not ...
- 3,183
0
votes
0
answers
32
views
Fulltext index search on sqlserver 2008 view
While I'm trying
CREATE VIEW [dbo].[FULLTEXT_VIEW] WITH SCHEMABINDING AS
SELECT ID, NAME FROM [dbo].VIEW_TABLE
GO
I always get this message: Cannot schema bind view 'dbo.FULLTEXT_VIEW'. 'dbo....
- 11
0
votes
1
answer
427
views
Full text search is not working if search for characters anywhere in the string
I have created a full text search index on ClientReference column but it doesn't work if i want to search for characters appearing any where in the string.
String = ' abcdef '
This won't work;
...
- 3,127
0
votes
1
answer
46
views
Questions in regards to full-text search with PDF SQL Server 2008 restricted to embedded text only?
What i'm curious about is lets say I have 100 pdfs. And all of them have the words "happy apple". Lets say that only 20 of these have embedded text that has "happy apple".
When i do a search for "...
user222427
0
votes
1
answer
88
views
Full text search using contains shows different results with same database content
I have 2 databases with full text search installed. One with real data and the other one just for testing.
Now my problem is I am having different search results with the same query.
Databases:
...
- 8,403
0
votes
1
answer
481
views
Return all rows indexed by FullText
In SQL Server 2008, I have OneTable that contains OneTextColumn that was full-text indexed.
Is there a way to find out what records of OneTable DID result in at least one record in the full-text ...
- 8,145
0
votes
1
answer
2k
views
FullText Index does not work even after I created them
Here is the error I get:
Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'database.dbo.crm_main'
because it is ...
- 7,742
1
vote
1
answer
71
views
SQL Server Free Text Search vs In clause
I am currently using IN clause on a varchar field. Will using Contains of FTS help in performance?
For e.g.
Select * from Orders where City IN (‘London’ , ‘New York’)
vs
Select * from Orders ...
- 13
5
votes
1
answer
1k
views
NHibernate LinqToHqlGenerator for SQL Server 2008 full text index 'Containing' keyword
I think I'm missing something fundamental when implementing a LinqToHql generator class.
I've successfully registered the SQL Server 2008 contains query using a custom dialect with this registration:
...
- 1,648
0
votes
1
answer
1k
views
SQL Server 2008: Turn off select stop words for full text search query using CONTAINS
Have an app that was using Microsoft SQL Server and needed to search data, found that for queries that had been like "series 6" or "series 66" would return results just if they had 'series' and ...
- 55
0
votes
1
answer
403
views
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 ...
- 1,417
1
vote
1
answer
217
views
T-SQL Contains not working for values with point as 2nd or 3rd symbol
There is a SQL statement, generated by stored procedure, looking like this:
SELECT Id, Name
FROM UInstitutions as UI
WHERE Contains(UI.Name, @ParamName)
It seems that if value has dot (.) as second ...
- 2,623
15
votes
1
answer
54k
views
SQL Fuzzy Matching
Hope i am not repeating this question. I did some search here and google before posting here.
I am running a eStore with SQL Server 2008R2 with Full Text enabled.
My requirements,
There is a ...
- 2,278
1
vote
1
answer
637
views
SQL SERVER 2008 how to use CONTAINSTABLE with 'ISAbout', 'AND','Weight(1.0)' Clause?
I have used the following, but giving error:-
SELECT Main.Id,
Main.Catid,
Main.ParentId,
Main.ARelation,
Main.CRelation,
Mytbl.RANK
FROM A as Main
INNER ...
- 31
5
votes
4
answers
5k
views
Using full-text search with PDF files in SQL Server 2008
I have SQL Server 2008 R2 and am trying to implement full-text search on a PDF BLOB.
I have installed the iFilter from Adobe and confirmed it is installed
Using
EXEC ...
user2024839
2
votes
2
answers
2k
views
How to create full text index for a multi language column?
I have a table called TestTable with the below schema.
---------------------------------------------------------
ID(Integer) | Text(nvarchar(450)) | LanguageCode(Integer)
-----------------------------...
- 1,806
0
votes
1
answer
529
views
Moving form Full text search in Sql Server To MySql
I already have a product in production where i used Entity Framework with SQL Server as db. I've used full text search wherein i store binary data (filestream) along with the file extension which is ...
- 440
3
votes
1
answer
2k
views
Possible to use fulltext indexes with views in SQL Server?
Is it possible to use FULLTEXT indexing with a view in Sql Server without creating the index on the view itself?
I was quite surprised to find that using CONTAINS(,) to query a column in a view doesn'...
- 24.1k
3
votes
2
answers
96k
views
Can you use DOES NOT CONTAIN in SQL to replace not like?
I have a table called logs.lognotes, and I want to find a faster way to search for customers who do not have a specific word or phrase in the note. I know I can use "not like", but my question is, ...
- 31
0
votes
1
answer
53
views
Build a dynamic search like apple - Simply need direction/guidance
I know this has been asked before, but I simply need educated advice on a direction to go.
I'm using SQL Server 2008 and have recently upgraded to full-text search.
I'm using HTML, jQuery, and can ...
- 3,230
0
votes
1
answer
104
views
How do I stop SQL 2008 throwing errors when Full Text Search is not installed?
I am calling IF (0 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) RETURN; at the beginning of my full text search stored procedure. This should force the stored procedure to exit if full text ...
- 4,047
1
vote
0
answers
155
views
sql server cannot return right fulltext search result for excel document
I am using sql server 2008 ,and have started fulltext service,and install 2010 ifilter from microsoft for it also.
Then I have a table with a filestream column ,add create fulltext index for it. ...
- 46
0
votes
1
answer
646
views
rebuild fulltext catalog will invoke a full population in sql server 2008
I had set Change Tracking to Manual,when I execute
sp_fulltext_catalog 'myfulltextCatalog','rebuild',
a rebuilding is started.But I have found that the PopulateStatus of the fulltext catalog is ...
- 46
0
votes
1
answer
100
views
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 ...
- 31
0
votes
1
answer
1k
views
singular and plural search in database
I want to implement searching like following criteria :
search should perform according to multiple keyword, for ex. keyword = Man, cat, bat
search should match singular and plural of the keyword if ...
- 2,780
12
votes
4
answers
13k
views
SQL Server Full-Text Search for exact match with fallback
First off there seems to be no way to get an exact match using a full-text search. This seems to be a highly discussed issue when using the full-text search method and there are lots of different ...
- 2,422
1
vote
1
answer
360
views
Best way to compare one column value with the words contained in the other column
My table structure is something like below.
Products { product_name, brand, model}
All are varchar fields (there are more fields but they are not related to my issue. There are nearly 5000000 in ...
- 1,887
1
vote
5
answers
3k
views
Spell check and word suggestion script in SQL Server
I'm developing a web application using ASP.NET and SQL Server 2008. I have about 1,000,000 articles in my DB and I've activated Full-Text-Search.
Now, I want to search in articles and I need 3 ...
- 1,674
1
vote
1
answer
402
views
Syntax error when using NEAR with maximum_distance value
How do I modify this query to search for the keywords that are only two words apart?
select id, SubjectText from dbo.email where contains
([ContentText],'execute NEAR class near program near code ...
- 11
2
votes
1
answer
2k
views
Create Full Text index script on all columns without specifying each column by name
How can I have a full text index on all columns without specifying individual column names via script in SQL Server?
My table has 50 columns, and I'd like the full text index to cover them all.
Can ...
