Code example 4-1SELECT VendorName AS Vendor, InvoiceDate AS DateFROM Vendors AS V JOIN Invoices AS I    ON V.VendorID = I.VendorID; (Refer to code example 4-1.) The name “V” is known as a/an ____________________________________.

To create a new table by using a SELECT statement, you code the ___________________________ clause.

To insert several rows selected from another table into a table, you can code an INSERT statement with a/an ______________ in place of the VALUES clause.

A union combines the rows from two or more _______________________.

Code example 4-2SELECT VendorName, InvoiceNumberFROM Invoices LEFT JOIN Vendors  ON Invoices.VendorID = Vendors.VendorID; (Refer to code example 4-2.) The total number of rows returned by this query must equal

When a column in a table is defined, it is given a data _________ that determines what kind of data it can store.

The ranking functions make it easy to include a column in a result set that provides the sequential ranking number of each row within a/an ___________________________.

If you code a column list in an INSERT statement that includes a column that’s defined with a default value, you can insert the default value for that column by coding the ____________________ keyword in the VALUES clause of the INSERT statement.

When you use the Management Studio to create a database, including its tables and indexes, the Studio actually generates and runs the _________________________ statements that are necessary to create the database.

To work with the data in a SQL Server database from a .NET application, you can use ADO.NET objects like