Microsoft® SQL Server 2008 R2 Unleashed

Four SQL clauses allow you to conduct full-text searches on your full-text index tables:

• CONTAINS—Specifies a strict exact match, with options to make the search flexible.

• CONTAINSTABLE—Returns a ranked rowset from SQL Server FTS implementing the Contains algorithm, which must be joined against the base table.

• FREETEXT—Specifies a stemmed search that returns results to all generations of the search phrase.

• FREETEXTTABLE—Returns a ranked rowset from SQL Server FTS implementing the FreeText algorithm, which must be joined against the base table.

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Microsoft® SQL Server 2008 R2 Unleashed by