Abstract
The filtering mechanism for XQuery has some differences and specifications when compared to the T-SQL WHERE clause. In my experience, when DBAs and Developers implement filters for XQuery, it is mostly based on a T-SQL strategy or to create dynamic SQL that is not efficient and could be very difficult to maintain, especially when the filter is implemented as dynamic SQL. This chapter will demonstrate many examples of how to implement filters for XQuery requests.
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsAuthor information
Authors and Affiliations
Rights and permissions
Copyright information
© 2018 Alex Grinberg
About this chapter
Cite this chapter
Grinberg, A. (2018). Filtering XML. In: XML and JSON Recipes for SQL Server. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3117-3_6
Download citation
DOI: https://doi.org/10.1007/978-1-4842-3117-3_6
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-3116-6
Online ISBN: 978-1-4842-3117-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books