2012年3月27日星期二

Full text search workaround?

Me and a friend are setting up a .net project on a shared hosting server....the thing is, they dont seem to allow the use of full text search....when i connect to the server on Enterprise Manager, the option for "Create new catalog" is disabled.

we need to give users the ability to search by keywords......what's a good workaround for this without using FTS?

any advice?

thanks.

G.Create queries that use the wildcart % for all the fields you want to search in ...
Only way you can do it ...|||Here is a nice example of some searching logic.

http://weblogs.sqlteam.com/jeffs/archive/2004/11/02/2460.aspx|||

% wildcards work really slow u should be carefull...

find a way to use full text search.

sql

没有评论:

发表评论