Technical Article

setting full text search using script

,

select *
from dbo.Employees
where freetext(*, 'jonh')

select Emp.*
from dbo.Employees Emp
INNER JOIN
FREETEXTTABLE ( dbo.Employees, *, 'jony desuza') AS Keytbl
ON Emp.EmpID = Keytbl.

select *
from dbo.Employees
where contains(*, 'jony desuza')

select Emp.*
from dbo.Employees Emp
INNER JOIN
CONTAINSTABLE ( dbo.Employees, *, 'jony desuza') AS Keytbl
ON Emp.EmpID = Keytbl.

exec sp_fulltext_catalog 'ftcEmployees', 'create', 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData'
go

exec sp_fulltext_table 'dbo.Employees', 'create', 'ftcEmployees', 'PK_tbl_fulltextExample_ID'
go

exec sp_fulltext_column 'dbo.Employees', 'FirstName', 'add'
go

exec sp_fulltext_column 'dbo.Employees', 'LastName', 'add'
go

exec sp_fulltext_column 'dbo.Employees', 'Adderss', 'add'
go

exec sp_fulltext_column 'dbo.Employees', 'ContactNo', 'add'
go

exec sp_fulltext_table 'dbo.Employees','activate';
go

exec sp_fulltext_catalog 'ftcEmployees', 'start_full';
go

exec sp_fulltext_table 'dbo.Employees', 'start_full';
go

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

Share

Join the discussion and add your comment

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

You rated this post out of 5. Change rating

Related content

External Article

Full Text Search Noise Words and Thesaurus Configurations

I have heard that Full Text Search uses a noise words to eliminate meaningless words in searches. I have also heard that a thesaurus is used, but I am not exactly sure how. Can you provide some details related to how both of these technologies are used in Full Text Search? I am interested in more of a background on these specific Full Text Search technologies as well as where the files are located and how I can update them.

2008-05-19

2,630 reads