Exam objectives in this chapter:
Work with Data
Query data by using SELECT statements.
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 ...