About the Store.Demographics xml Column
Using the AdventureWorks2008R2 sample database for illustration, resellers buy products from Adventure Works Cycles and sell them in retail outlets. The usual demographic information for these resellers, such as annual revenue, annual sales, business type, and year opened, is stored in the Demographics column of xml data type in the Store table.
This is a typed xml column. The schemas used for this column can be viewed at this Microsoft Web site. This column uses the StoreSurvey XML schema.
This is a sample XML instance stored in the Store.Demographics column:
<StoreSurvey xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey"> <AnnualSales>300000</AnnualSales> <AnnualRevenue>30000</AnnualRevenue> <BankName>International Bank</BankName> <BusinessType>BM</BusinessType> <YearOpened>1970</YearOpened> <Specialty>Road</Specialty> <SquareFeet>7000</SquareFeet> <Brands>3</Brands> <Internet>T1</Internet> <NumberEmployees>2</NumberEmployees> </StoreSurvey>
Run the following query to find more XML instances:
USE AdventureWorks2008R2; GO SELECT Demographics FROM Sales.Store WHERE Demographics IS NOT NULL;