Abstract
In Chapter 9 you learned about some exciting new data types that Microsoft introduced with SQL Server 2005 and 2008. In this chapter, you will learn about some of the new functions and advanced queries available with these most recent releases. For example, you will learn more about common table expressions (CTEs), how to write a pivot query, how to use the new ranking functions, and more. As a beginning T-SQL developer, you may or may not need this information right away. This chapter does not contain any exercises, but I encourage you to experiment and come up with your own examples for any of the features that you are interested in. Consider the information in this chapter as a head start in becoming an expert T-SQL developer.
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 subscriptionsPreview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Kathi Kellenberger
About this chapter
Cite this chapter
Kellenberger, K. (2009). Writing Advanced Queries. In: Beginning T-SQL 2008. Apress. https://doi.org/10.1007/978-1-4302-2462-4_10
Download citation
DOI: https://doi.org/10.1007/978-1-4302-2462-4_10
Publisher Name: Apress
Print ISBN: 978-1-4302-2461-7
Online ISBN: 978-1-4302-2462-4
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books