O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Full-Text Searches

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

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

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

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

FREETEXTTABLE—Returns ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required