Chapter 6. Querying Full-Text Data

Exam objectives in this chapter:

  • Work with Data

    • Query data by using SELECT statements.

  • Modify Data

    • Work with functions.

It is hard to imagine searching for something on the web without modern search engines like Bing or Google. However, most contemporary applications still limit users to exact searches only. For end users, even the standard SQL LIKE operator is not powerful enough for approximate searches. In addition, many documents are stored in modern databases; end users would probably like to have powerful search capabilities inside document contents as well.

Microsoft SQL Server 2012 enhances the full-text search support that was substantially available in previous editions. This chapter explains how to use ...

Get Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.