Hello Freinds,
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 job in c,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.