Views | SQL 2005 Adventure Works OLTP |
Stores (names and addresses) that sell Adventure Works Cycles products to consumers.
Properties
Transactional Uses cursors Executes procedures Dynamic content Encrypted No No No No No
Data Source Activity
Accesses Description Person.Address Street address information for customers, employees, and vendors. Person.Contact Names of each employee, customer contact, and vendor contact. Person.ContactType Lookup table containing the types of contacts stored in Contact. Person.CountryRegion Lookup table containing the ISO standard codes for countries and regions. Person.StateProvince State and province lookup table. Sales.Customer Current customer information. Also see the Individual and Store tables. Sales.CustomerAddress Cross-reference table mapping customers to their address(es). Sales.Store Customers (resellers) of Adventure Works products. Sales.StoreContact Cross-reference table mapping stores and their employees.
Output Recordset
Column Description CustomerID Name ContactType Title FirstName MiddleName LastName Suffix Phone EmailAddress EmailPromotion AddressLine1 AddressLine2 City StateProvinceName PostalCode CountryRegionName AnnualSales AnnualRevenue BankName BusinessType YearOpened Specialty SquareFeet Brands Internet NumberEmployees
Data source Description Person.Address Street address information for customers, employees, and vendors. Person.Contact Names of each employee, customer contact, and vendor contact. Person.ContactType Lookup table containing the types of contacts stored in Contact. Person.CountryRegion Lookup table containing the ISO standard codes for countries and regions. Person.StateProvince State and province lookup table. Sales.Customer Current customer information. Also see the Individual and Store tables. Sales.CustomerAddress Cross-reference table mapping customers to their address(es). Sales.Store Customers (resellers) of Adventure Works products. Sales.StoreContact Cross-reference table mapping stores and their employees.
Applies to
Views