a question about freetext store procedure

• nazaninahmady_sh

  Default port

  Points: 1465

  More actions

  October 5, 2009 at 2:29 am

  #142273

  Hi

  i wrote a store Procedure, it is simple but it does not work correctly.

  This is my SP:

  set ANSI_NULLS ON

  set QUOTED_IDENTIFIER ON

  go

  ALTER PROCEDURE [dbo].[Searching_SP]

  @item nvarchar(500)

  AS

  Begin

  select * from [File]

  where

  freetext (FileName,@item)

  end

  anf forexample this my Table:

  FileCode FileName File Url Desc Tag

  2 Norton anti b bb Null

  3 anti zibra gg ggg Null

  Forexample when i put @item=anti

  it dont have Record 3 in my result,

  this sp only brings Record 2 for me,

  what is my mistake?

  thanks

• dsdeming

  Ten Centuries

  Points: 1236

  More actions

  October 5, 2009 at 6:44 am

  #1061675

  If the column names and sample data you've listed are correct, you should be getting back row 3 and not row 2. I suspect that there's something wrong with the data we're being shown. Can you show us the results, with column headings, of:

  SELECT * FROM yourTable WHERE FileCode in(2,3)