Databases Reference
In-Depth Information
Beginning with Queries
A query is a technique to extract information from a database. You need a query window
into which to type your query and run it so data can be retrieved from the database.
n Note Many of the examples from this point forward require you to work in SQL Server Management
Studio Express. Refer back to “Using SQL Server Management Studio Express” in Chapter 2 for instructions
if you need to refresh your memory on how to connect to SSMSE.
Try It Out: Running a Simple Query
1. Open SQL Server Management Studio Express, expand the Databases node, and
select the AdventureWorks database.
2. Click the New Query button in the top-left corner of the window, as shown in
Figure 4-1, and then enter the following query:
Select * from Sales.SalesReason
Figure 4-1. Writing a query
Search WWH ::




Custom Search