Last post Jun 27, 2011 03:17 PM by atconway
Feb 19, 2006 02:35 PM|Joannes Vermorel|LINK
Feb 20, 2006 08:07 AM|mbanavige|LINK
SQL server uses a specific syntax to query the full text indexes.
you'll just need to parse your users input to create the appropriate query
Feb 22, 2006 01:29 PM|Caddre|LINK
You can use Microsoft implementation of Full Text SQL predicates CONTAINS and FREETEXT plus the table version CONTAINSTABLE and FREETEXTTABLE with ANSI SQL and T-SQL in your queries. I have not used the SQL Server 2005 version but in SQL Server 2000 Full
text is dependent on Microsoft Search Service a separate install and the Search Catalog must be populated to get expected search results. The links below are a walk through tutorial for SQL Server 2000 and Full Text blog run by a former member of the Microsoft
Full Text team. When you are through with the tutorial run a search for what is new in Full Text in SQL Server 2005 BOL (books online). Hope this helps.
Jun 26, 2011 05:28 PM|JonathanWood|LINK
I've posted some free code that will convert more Google-like queries to query syntax required by FTS. I've posted the code and article at http://www.blackbeltcoder.com/Articles/data/easy-full-text-search-queries.
Jun 27, 2011 03:17 PM|atconway|LINK
One possible way is to store the textual content of your site in the database (sounds like you might be doing this), and then add a 'Full Text Index' on the database table(s) that contains this information. You can then run SQL queries based on free form
text entered by the user (i.e. search engine esque) using the CONTAINS and FREETEXT Functions. The robustness of these (2) functions are quite vast and have a lot of options built in. Without having a team (or army) of developers like Google, this out-of-the-box
search functionality is hard to beat. In SQL2008 this is really fast and I have been quite pleased.
Look at the following for some more information:
Full-Text Indexing Overview:
...this one has pictures:
Full-Text Predicates and Functions Overview:
Hope this helps!