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 _________________…
A union combines the rows from two or more _______________________.
Code example 4-2SELECT VendorName, InvoiceNumberFROM Invoice…
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 ____…
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…
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 includ…
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, inc…
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 a…
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…
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/…
The IIF function determines the value it returns based on a/an ____________________ expression.