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…
To create a new table by using a SELECT statement, you code the ___________________________ clause.
To insert several rows selected from another table into a ta…
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