Re: full-text across multiple columns

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Kane (jt-kane_at_comcast.net)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 14:42:55 -0800

You're welcome, Peter,
The results that you are seeing in your queries is by design for SQL Server
7.0 post-SP2 and for SQL Server 2000, per the KB articles ;-(.

However, in the next release of SQL Server (codname Yukon) and now
officially called: "SQL Server 2005", you will be able to do multi-column
SQL FTS queries with the following syntax:

-- new Yukon (SQL Server 2005) SQL FTS syntax:
SELECT PrimaryKey, Col1, Col2, Col3
  FROM SQLFTS_Table
    WHERE CONTAINS((Col2, Col3 ), '"xxx" AND "yyy"')

Other than waiting for Yukon which has been delayed until 1st half of 2005,
and if you're interested, there are non-MSSearch methods to achieving what
you're looking for. Feel free contact me directly, if you want to pursue
this further.

Regards,
John

"Peter Sleziak" <sleziak@kn.vutbr.cz> wrote in message
news:u#0PNgHCEHA.1544@TK2MSFTNGP09.phx.gbl...
> Thank you,
> but what if I want select only from two columns. For example
>
> SELECT * FROM FT_TBL WHERE
> (CONTAINS(description, 'xxx') OR
> CONTAINS(info, 'xxx'))
> AND
> (CONTAINS(description, 'yyy') OR
> CONTAINS(info, 'yyy'))
>
> it returns me what i want:
>
> -----------------------------------
> | Description | Info | extra_info |
> |---------------------------------|
> | xxx | yyy | yyy |
> -----------------------------------
>
> but when I use CONTAINS(*, ...) it returns wrong rows.
> If you have an any idea please HELP !!! :)
> Thanks
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... Access ships with MSDE.. ... >SQL Server Books Online (again-- Access ships with freeware SQL Server ... better ways to achieve their results through queries. ...
    (microsoft.public.excel)
  • Re: Official Status of SQLServer 2005 ADP
    ... solution might be to use ADP. ... With MDB and Linked tables, the only ways of accelerating things are the use ... of Views and the cumbersome use of SQL passthrough queries. ... > SQL Server, and carry on using Access like I aways had. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Server 2000 and Latching problem
    ... While the way we indexed our tables and the way we wrote the queries etc ... "chances are you are getting latches because you are ... query on the results the query .. ... SQL Server 2000 and Latching problem ...
    (microsoft.public.sqlserver.connect)
  • Re: Sql server as back end
    ... There is an option in the Tools menu, Database Utilities, for Upsize to SQL Server. ... But after that, the queries should generally work, shouldn't they? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL Server (?) performance issues
    ... it's usually that those queries are being blocked by something else. ... Columnist, SQL Server Professional ... exact counters are being watched, but we are being told that all the ... all is fine and there is plenty of spare capacity. ...
    (microsoft.public.sqlserver.server)