Day 1

Quiz

1:How can I tell whether the words I type into the Query Analyzer editor are keywords?
A1: Any words that you enter in the Query Analyzer editor which are keywords will be changed to the color blue. These default colors can be changed in the Options dialog within the Query Analyzer.
2:Identify the column and table names in the following SELECT statement:
select OrderID,
           CustomerID,
           OrderDate,
           ShipName,
           ShippedDate
From Orders

A2: The columns in the SELECT statement are all listed between the SELECT and FROM keywords. The table name follows the FROM keyword.
3:The following query does not work. Why?
Select * Employees

A3: The SELECT statement requires the keyword FROM before the actual table names.

Exercises

1:Using the Employees table from earlier today, write a query to return just the EmployeeID and title for each employee.
A1: Answer:
Select EmployeeID,
         Title
From Employees

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset