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.
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.