Object type: Data view

Displays the content from each element in the xml column Demographics for each customer in the Sales.Individual table.

Properties 

Transactional	Uses cursors	Executes procedures	Dynamic content	Encrypted
No	No	No	No	No

Data Source Activity 

Accesses	Description
Sales.Individual	Demographic data about customers that purchase Adventure Works products online.

Output Recordset 

Column	Description
CustomerID
TotalPurchaseYTD
DateFirstPurchase
BirthDate
MaritalStatus
YearlyIncome
Gender
TotalChildren
NumberChildrenAtHome
Education
Occupation
HomeOwnerFlag
NumberCarsOwned
Hobby

Data source	Description
Sales.Individual	Demographic data about customers that purchase Adventure Works products online.

Called functions 

Name	Description
Demographics.value

Applies to

Views

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation