Jump to content

Phanikumar

Members
  • Posts

    2
  • Joined

  • Last visited

Everything posted by Phanikumar

  1. Hello, I had doubt about multithreading concept in asp.net. I saw the examples in vb.net and asp.net, in this examples I found the use of threading is main thread runs in front end while other thread works in back end. I need to work it out in a web application in visual basic (vb). Please give brief details about this concept and example, such as the importance of threading and how to use. Thanking You, Phani.
  2. 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.
×
×
  • Create New...