C H A P T E R 2
Writing Simple SELECT Queries
Chapter 1 had you preparing your computer by installing SQL Server 2012 and the AdventureWorks2012 sample database. You learned how to get around in SQL Server Management Studio and a few tips to help make writing queries easier.
Now that you’re ready, it’s time to learn how to retrieve data from a SQL Server database. You will retrieve data from SQL Server using the
SELECT statement, starting with the simplest syntax. This chapter will cover the different parts, called clauses, of the
SELECT statement so that you will be able to not only retrieve data but also filter and order it. The ultimate goal is to get exactly the data you need from your database—no more, no less.
Beginning in this chapter, ...