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

The rows in a table are kept in the sequence that’s based on its  __________________________ index.

The IIF function determines the value it returns based on a/an ____________________ expression.