MS SQL search

[ash]

I want to search the content of some database tables,
do asp has some function or tool do this?
thx

[Ray Costanzo [MVP]]

Can you be more specific? If you want content from a database, you query
it.

Ray at work

"ash" <as*@gmail.comwrote in message
news:uF**************@TK2MSFTNGP02.phx.gbl...

>I want to search the content of some database tables,
do asp has some function or tool do this?
thx

[ash]

is there any function in asp read through all the tables in the db and
search the all content that matched, then display to the link relevant asp.

thx

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial¦b¶l¥ó
news:eQ**************@TK2MSFTNGP02.phx.gbl ¤¤¼¶¼g...

Can you be more specific? If you want content from a database, you query
it.

Ray at work

"ash" <as*@gmail.comwrote in message
news:uF**************@TK2MSFTNGP02.phx.gbl...

I want to search the content of some database tables,
do asp has some function or tool do this?
thx

[Bob Barrows [MVP]]

No. you need to look into Full-text indexing, which is built into SQL
Server.

ash wrote:

is there any function in asp read through all the tables in the db and
search the all content that matched, then display to the link
relevant asp.

thx

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial¦b¶l¥ó
news:eQ**************@TK2MSFTNGP02.phx.gbl ¤¤¼¶¼g...

>Can you be more specific? If you want content from a database, you
query it.

Ray at work

"ash" <as*@gmail.comwrote in message
news:uF**************@TK2MSFTNGP02.phx.gbl...

>>I want to search the content of some database tables,
do asp has some function or tool do this?
thx

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[ash]

Is Full-text indexing is for searching the for all tables in the db with
matching word in the content? where can i find it in SQL Server?
Thx

Best Regards, Stephy Ku Innovation Square 2756 6618
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom¦b¶l¥ó
news:uq**************@TK2MSFTNGP03.phx.gbl ¤¤¼¶¼g...

No. you need to look into Full-text indexing, which is built into SQL
Server.

ash wrote:

is there any function in asp read through all the tables in the db and
search the all content that matched, then display to the link
relevant asp.

thx

"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial¦b¶l¥ó
news:eQ**************@TK2MSFTNGP02.phx.gbl ¤¤¼¶¼g...

Can you be more specific? If you want content from a database, you
query it.

Ray at work

"ash" <as*@gmail.comwrote in message
news:uF**************@TK2MSFTNGP02.phx.gbl...
I want to search the content of some database tables,
do asp has some function or tool do this?
thx

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Bob Barrows [MVP]]

ash wrote:

Is Full-text indexing is for searching the for all tables in the db
with matching word in the content?

Ummmm ... that's why I suggested it ....

where can i find it in SQL Server?
Thx

I've never used it myself so all I can tell you is to look it up in BOL
(Books Online).
You will have better luck looking for support in a sqlserver group. I think
they have one devoted to full-text indexing issues ... yes, it's called
microsoft.public.sqlserver.fulltext

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"