Full text-searching, text-indexing

What is these about in SQl Server 2000 and MSDE ?It constructs an index of all the words in the content you are full-text
indexing which is similar to the index you will find at the back of a book.
A full-text query against a word or a phrase will return rows which contain
that word or phrase.
SQL FTS does not ship with MSDE, but is a downloadable component with SQL
Server Express (the SQL 2005 "version"/flavor of MSDE).
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:ONFN4NFaGHA.4620@.TK2MSFTNGP04.phx.gbl...
> What is these about in SQl Server 2000 and MSDE ?
>|||As we are going to develop a full text-search application using SQL
Server/MSDE.
Is there any startup guide ?
So it seems not simple as:
SELECT *
FROM tlb1
WHERE Field1 like "%smith%"
or Field2 like "%smith%"
or ...
SELECT *
FROM tlb2
WHERE Field1 like "%smith%"
or Field2 like "%smith%"
or ...
.....
because I need to fetch the fields from all tables when the contents of each
table field has a string like "smith".
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:O6XGcaGaGHA.3992@.TK2MSFTNGP05.phx.gbl...
> It constructs an index of all the words in the content you are full-text
> indexing which is similar to the index you will find at the back of a
book.
> A full-text query against a word or a phrase will return rows which
contain
> that word or phrase.
> SQL FTS does not ship with MSDE, but is a downloadable component with SQL
> Server Express (the SQL 2005 "version"/flavor of MSDE).
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:ONFN4NFaGHA.4620@.TK2MSFTNGP04.phx.gbl...
>|||Is it possible to create a full-text index of several table? From the
example I got I can only create a full-text index for single table.
"Alan" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:On#QVi8cGHA.1204@.TK2MSFTNGP02.phx.gbl...
> As we are going to develop a full text-search application using SQL
> Server/MSDE.
> Is there any startup guide ?
> So it seems not simple as:
> SELECT *
> FROM tlb1
> WHERE Field1 like "%smith%"
> or Field2 like "%smith%"
> or ...
> SELECT *
> FROM tlb2
> WHERE Field1 like "%smith%"
> or Field2 like "%smith%"
> or ...
> .....
> because I need to fetch the fields from all tables when the contents of
each
> table field has a string like "smith".
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:O6XGcaGaGHA.3992@.TK2MSFTNGP05.phx.gbl...
> book.
> contain
SQL[vbcol=seagreen]
>