Abstract
Once you’ve built and populated full-text indexes in your database, you can begin querying them to retrieve relevant data. This chapter is designed to provide an introduction to the features available through full-text search predicates and functions, and as a guide to the powerful search query grammar of SQL Server iFTS. SQL Server provides powerful full-text search querying capabilities, from the most basic phrase search to extremely complex searches involving Boolean operators, proximity searches, and weighted search terms. We begin our discussion of SQL Server iFTS with an introduction to the two available SQL Server search predicates, CONTAINS and FREETEXT.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Michael Coles and Hilary Cotter
About this chapter
Cite this chapter
(2009). Basic and Advanced Queries. In: Pro Full-Text Search in SQL Server 2008. Apress. https://doi.org/10.1007/978-1-4302-1595-0_3
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1595-0_3
Publisher Name: Apress
Print ISBN: 978-1-4302-1594-3
Online ISBN: 978-1-4302-1595-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books