Groups | Blog | Home
all groups > inetserver asp general > august 2006 >

inetserver asp general : MS SQL search


ash
8/30/2006 12:00:00 AM
I want to search the content of some database tables,
do asp has some function or tool do this?
thx

Ray Costanzo [MVP]
8/30/2006 9:40:03 AM
Can you be more specific? If you want content from a database, you query
it.

Ray at work

[quoted text, click to view]

ash
8/31/2006 12:00:00 AM
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:eQcrNnDzGHA.4596@TK2MSFTNGP02.phx.gbl ¤¤¼¶¼g...
[quoted text, click to view]

Bob Barrows [MVP]
8/31/2006 12:00:00 AM
No. you need to look into Full-text indexing, which is built into SQL
Server.

[quoted text, click to view]

--
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
9/1/2006 12:00:00 AM
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]" <reb01501@NOyahoo.SPAMcom> ¦b¶l¥ó
news:uq9a8lOzGHA.1292@TK2MSFTNGP03.phx.gbl ¤¤¼¶¼g...
[quoted text, click to view]

Bob Barrows [MVP]
9/1/2006 8:36:54 AM

[quoted text, click to view]

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

[quoted text, click to view]

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"

AddThis Social Bookmark Button