2012年3月21日星期三

Full text search

Hi,
Is full text search only for image column?
Thanks
No, also the (n)(var)char columns.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"mecn" <mecn2002@.yahoo.com> wrote in message news:eeVYADdbFHA.3712@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is full text search only for image column?
> Thanks
>
|||Thanks Tibor.
What's the benefit for full text search.
If I run a select statement in sql query, Is this using full text serach
automatically?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:#N4KrddbFHA.2968@.TK2MSFTNGP10.phx.gbl...
> No, also the (n)(var)char columns.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
news:eeVYADdbFHA.3712@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
|||You need to use special TSQL language elements to use full text indexes, and there in is the power
of FT indexes. Read in Book sOnline about CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTABLE.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"mecn" <mecn2002@.yahoo.com> wrote in message news:%239yPeldbFHA.2288@.TK2MSFTNGP14.phx.gbl...
> Thanks Tibor.
> What's the benefit for full text search.
> If I run a select statement in sql query, Is this using full text serach
> automatically?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:#N4KrddbFHA.2968@.TK2MSFTNGP10.phx.gbl...
> news:eeVYADdbFHA.3712@.TK2MSFTNGP09.phx.gbl...
>

没有评论:

发表评论