开发者

SQL 2008 Full Text Search from Classic ASP?

开发者 https://www.devze.com 2023-01-30 06:10 出处:网络
I have a legacy app in which I need to enable search. Recently we\'ve switched to SQL 2008 and I was wondering to do it with it\'s Full Text Search.

I have a legacy app in which I need to enable search.

Recently we've switched to SQL 2008 and I was wondering to do it with it's Full Text Search.

However my question is...is there API available for Cl开发者_C百科assic ASP? Any references?


You can use Full text search features of the SQL server. Create a stored procedure uisng Free text searh indexing features(Use contains & Free text keywords in SQL query). You need create Index and catelog for your database.

Call the stored procedure from classic ASP.


I think full text search is a completly service side feature and that you only send normal SQL queries in which case normal ADODB should be sufficent to use it.

But I have never tried fulltext service my self so I am not a 100 % sure.

0

精彩评论

暂无评论...
验证码 换一张
取 消