SQL Query Using Full Text Engine inSQL 2005

Phanikumar

New member
Joined
Sep 22, 2008
Messages
1
Programming Experience
Beginner
Hello Friends,

I need help regarding a SQL Query
We are designing a job site, and there is a job search. In this search
There is a textbox for entering the keywords or any string for the search.
After the Search button click I should give results of the string in a data grid.
But I had doubt in SQL Query. Here I am using Full text engine in SQL 2005. And the queries are FREETEXTTABLE and COTAINSTABLE.
The rank differs for both.
Example:
Enter Keywords: I want jobinc,vb company is microsoft

FREETEXTABLE QUERY:

Select * From jobposting as posting Innerjoin Freetextable (jobposting,*,'"*I*" | "*want*" | "*job*" | "*in*" | "*.net*" | "*vb*" | "*company*" | "*is*" | "*microsoft*" ') as frees ON trees. [Key]=posting. [ID] order by Rank Desc


CONTAINSTABLE QUERY:

Select * From jobposting as posting Innerjoin Containstable (jobposting,*,'"*I*" | "*want*" | "*job*" | "*in*" | "*.net*" | "*vb*" | "*company*" | "*is*" | "*microsoft*" ') as frees ON trees. [Key]=posting. [ID] order by Rank Desc

Suggest me the appropriate query for my search,

Thanking You,
Phani.
 

Latest posts

Back
Top