Object type: Data view

Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.

Properties 

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

Data Source Activity 

Accesses	Description
Production.ProductModel	Product model classification.

Output Recordset 

Column	Description
ProductModelID
Name
Summary
Manufacturer
Copyright
ProductURL
WarrantyPeriod
WarrantyDescription
NoOfYears
MaintenanceDescription
Wheel
Saddle
Pedal
BikeFrame
Crankset
PictureAngle
PictureSize
ProductPhotoID
Material
Color
ProductLine
Style
RiderExperience
rowguid
ModifiedDate

Data source	Description
Production.ProductModel	Product model classification.

Applies to

Views

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