Sams Teach Yourself Transact-SQL in 21 Days, Second Edition

Day 5

Quiz

1:

For each of the following items, identify the database name, owner, table name, and column name (if available). Where the value will default, indicate that. CompanyName Customers.CompanyName Northwind.dbo.Products.QuantityPerUnit Northwind..Products.UnitPrice dbo.Suppliers.City Mary.Suppliers.City Suppliers dbo.Suppliers

A1:

Answer: CompanyName—Column name in a table in query. Unqualified, so cannot determine other information. Customers.CompanyName—Column name in Customers table. Current database is assumed. Table is owned by current user or dbo. Northwind.dbo.Products.QuantityPerUnit—Fully qualified column name of QuantityPerUnit column in Products table owned by dbo in the Northwind database. Northwind..Products.UnitPrice—Same as (c), except ...