Export (0) Print
Expand All

About the Store.Demographics xml Column

Using Adventure Works 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 AdventureWorksStoreSurvey 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:

SELECT Demographics
FROM   Sales.Store

Community Additions

ADD
Show:
© 2014 Microsoft