O'Reilly logo

Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 by Dejan Sarka Itzik Ben-Gan and Ron Talmage

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

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 ...

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