Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gagsbd

    Structured query vs Full Search Query

    Here is the fukk scriot of my SP. This SP is on a different table but, the concept is the same SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[GetJob_DetailsSummaryByAny] @categoryId int = null, @keywords nvarchar(255) = null, @state nvarchar(50)= null, @city...
  2. gagsbd

    Structured query vs Full Search Query

    Hey Guys, Thanks for all your feedback. I approched this problem as described below. I do not know whether it is a good practice. I created another text fields called searchText, basically in this column,I will be storing the content of all other fileds that are searchable i.e CategoryId...
  3. gagsbd

    Structured query vs Full Search Query

    Hi ESquared, Yes it is a typo. Wht you mean by OPs? I will post the query plan later today. Thanks
  4. gagsbd

    Structured query vs Full Search Query

    Hello Everyone, I have a table with the below fields CategoryId (int) Code (varchar) City (varchar) State (varchar) Zip (varchar) DocumnetText (text) I am developing a web application, where user can search on any combination of the fileds. DocumnetText is searched on keywords. Where...

Part and Inventory Search

Back
Top