Abstract
In this chapter, you will learn about coding queries in SQL Server 2012. SQL Server uses T-SQL as its language, and it has a wide variety of functions and constructs for querying. You will see how to use SQL Server Management Studio and the AdventureWorks database to submit queries for various scenarios of querying data. This chapter covers the following:
-
Retrieving data
-
Using the GROUP BY clause
-
Pattern matching
-
Using aggregate functions
-
Using DATETIME functions
-
Using the list operator
-
Using the range operator
-
Finding null values
-
Using joins
This is a preview of subscription content, log in via an institution to check access.
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
© 2012 Vidya Vrat Agarwal
About this chapter
Cite this chapter
Agarwal, V.V. (2012). Querying Databases. In: Beginning C# 5.0 Databases. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4261-1_5
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4261-1_5
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4260-4
Online ISBN: 978-1-4302-4261-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books