Understanding SQL Server Full-Text Indexing

Understanding SQL Server Full-Text Indexing in MSSQL Server 2000 and MSSQL Server 2005

Microsoft SQL Server supports T-SQL, an implementation of ANSI standard SQL. T-SQL is designed to (among other things) search for matches in your data. For example, if you've created a table with a column named Notes you could construct these queries:

SELECT * FROM MyTable WHERE Notes = 'Deliver Tuesday'

SELECT * FROM MyTable WHERE Notes LIKE '%caution%'

But what if you're not looking for an exact match, either to the full text of the column or a part of the column? That's when you need to go beyond the standard SQL predicates and use SQL Server's full-text search capabilities. With full-text searching, you can perform many other types of search:

• Two words near each other
• Any word derived from a particular root (for example run, ran, or running)
• Multiple words with distinct weightings
• A word or phrase close to the search word or phrase

detail...

powered by performancing firefox