Object type: Data view

Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions.

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
Instructions
LocationID
SetupHours
MachineHours
LaborHours
LotSize
Step
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