Views | SQL 2005 Adventure Works OLTP |
Individual customers (names and addresses) that purchase Adventure Works Cycles products online.
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.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.Individual Demographic data about customers that purchase Adventure Works products online.
Output Recordset
Column Description CustomerID Title FirstName MiddleName LastName Suffix Phone EmailAddress EmailPromotion AddressLine1 AddressLine2 City StateProvinceName PostalCode CountryRegionName Demographics
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.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.Individual Demographic data about customers that purchase Adventure Works products online.
Applies to
Views