Full-Text Search

Cuvinte asemanatoare, comparare stringuri

boldicu — Mon, 19 Jan 2009 14:55:58 GMT

Folosing FREETEXT() sau CONTAINS() e posibil sa gaseasca rezultate daca se cauta dupa un cuvant asemanator cu cel care exista in tabela, de exemplu cand cauti dupa "ASRIPIN" sau "ASP IRIN" in loc de "ASPIRIN" ? In general cand nu se introduce corect cuvantul de cautat dar e asemanator.

Am inteles ca FREETEXT ar face un fuzzy search dar nu am reusit sa-l conving.

Multumesc

How to check if full-text indexes exist on a table?

xmldeveloper — Wed, 18 Jan 2006 14:01:13 GMT

Using OBJECTPROPERTY function and TableHasActiveFulltextIndex parameter. OBJECTPROPERTY(table_id, 'TableHasActiveFulltextIndex') will return a value of 1 when at least one column of a table is added for indexing.
CODE:

SELECT OBJECTPROPERTY(OBJECT_ID('MySchema.MyTable'), 'TableHasActiveFulltextIndex');
GO

REFERENCE: "Obtaining Full-Text Property Values using Transact-SQL Functions" http://msdn2.microsoft.com/ms142579.aspx

How to check if full-text querying is enabled for a database ?

xmldeveloper — Wed, 18 Jan 2006 13:55:45 GMT

Using DATABASEPROPERTY function and IsFullTextEnabled parameter.
CODE:

USE AdventureWorks;
GO
SELECT DATABASEPROPERTY('AdventureWorks', 'IsFullTextEnabled');
GO

REFERENCE: "Obtaining Full-Text Property Values using Transact-SQL Functions" http://msdn2.microsoft.com/ms142579.aspx