Re: Fulltext syntax questions

In SQL 2005 you do it like this

select * from tblname where contains((Col1,Col2), 'search')
in SQL 2000 you can query a single column by name or all fulltext indexed
columns with a *.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"morphius" <morphius@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1B024DBC-EFED-448E-A688-562C83C5475B@xxxxxxxxxxxxxxxx
1. How do i search multiple columns in one table
Select name, jobtype, address from Clients
where contains|freetext (....?)


2. How do i search multiple columns in multiple tables. Do we still need a
join here or fulltext search will handle that?
Select a.name, a.jobtype, a.address, b.bonus
from a, b
where contains|freetext(....?)


.

Relevant Pages

  • Re: SQL*PLUS select statment
    ... single column; Here is an example: ... I know this has to be possible, but I lack the SQL skill to get to ... The two decodes 'join' the RN from query b) to query a), ... I tend to agree with Sybrand - the produced resultset is triple faked. ...
    (comp.databases.oracle.misc)
  • Re: SQL*PLUS select statment
    ... The query runs fine but I need to manipulate the data into a ... single column; Here is an example: ... I know this has to be possible, but I lack the SQL skill to get to ...
    (comp.databases.oracle.misc)
  • Re: Fulltext syntax questions
    ... If you search for SQL AND Server if SQL appears in col1 and Server appears in col2, you will not get a match with contains. ... How do i search multiple columns in multiple tables. ... join here or fulltext search will handle that? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
Loading