關於 ProductModel.Instructions xml 資料行
ProductModel 資料表中的 Instructions 資料行會將製造指示儲存為 XML 文件。這些文件是使用 Microsoft Word .NET 建立的。
每個 XML 文件都包含製造特定產品型號的完整指示。不過，每個產品型號可包含好幾項產品。例如，Road 450 是自行車產品型號。此產品型號有好數種自行車，如 Road 450 Red 25 和 Road 450 Green 48。在自行車產品型號之間的主要差異是在顏色及尺寸。
例如，HH Mountain Frame、LL Mountain Frame 和 ML Mountain Frame 是具有唯一產品識別碼的特定產品，但全都是 Mountain Bike Frame 產品型號的車架類型。
Product 資料表中的 ProductID 資料行可識別每一個產品。Product 中的 ProductModelID 資料行則識別產品所屬的產品型號。
製造過程會將產品從一個工作中心帶到另一個工作中心，而 XML 文件會描述每一個工作中心的製造步驟。在描述製造步驟時，工具、原料、藍圖和圖表全部都會用 XML 標記包住。因此，您可以查詢標記。例如，您可以使用 XQuery 來尋找在生產越野自行車時會用到的所有工具。
這是 xml 類型的資料行。您可以在此 Microsoft 網站檢視此資料行所使用的結構描述。此資料行使用 AdventureWorks2008R2 ProductModelManuInstructions XML 結構描述。
XML 執行個體範例
這是儲存在 ProductModel.Instructions 資料行中的 XML 執行個體範例：
<root xmlns="https://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelManuInstructions">
Adventure Works CyclesFR-210B Instructions for Manufacturing HL Touring FrameSummaryThis document contains manufacturing instructions for manufacturing the HL Touring Frame, Product Model 7. Instructions are work center specific and are identified by Work Center ID. These instructions must be followed in the order presented. Deviation from the instructions is not permitted unless an authorized Change Order detailing the deviation is provided by the Engineering Manager.
<Location LaborHours="2.5" LotSize="100" MachineHours="3"
SetupHours="0.5" LocationID="10">
Work Center - 10 Frame FormingThe following instructions pertain to Work Center 10. (Setup hours = .5, Labor Hours = 2.5, Machine Hours = 3, Lot Sizing = 100)
<step>Insert <material>aluminum sheet MS-2341</material> into the
<tool>T-85A framing tool</tool>.</step>
<step>Attach <tool>Trim Jig TJ-26</tool> to the upper and lower right corners of the aluminum sheet. </step>
<step>Using a <tool>router with a carbide tip 15</tool>
, route the aluminum sheet following the jig carefully. </step>
<step>Insert the frame into <tool>Forming Tool FT-15</tool> and press Start. </step>
<step> When finished, inspect the forms for defects per Inspection Specification <specs>INFS-111</specs>.</step>
<step>Remove the frames from the tool and place them in the Completed or Rejected bin as appropriate.</step>
</Location>
<Location LaborHours="1.75" LotSize="1" MachineHours="2" SetupHours="0.15" LocationID="20">
Work Center 20 - Frame WeldingThe following instructions pertain to Work Center 20. (Setup hours = .15, Labor Hours = 1.75, Machine Hours = 2, Lot Sizing = 1)
<step>Assemble all frame components following blueprint
<blueprint>1299</blueprint> . </step>
<step>Weld all frame components together as shown in illustration
<diag>3</diag> </step>
<step>Inspect all weld joints per Adventure Works Cycles Inspection Specification <specs>INFS-208</specs> . </step>
</Location>
<Location LaborHours="1" LotSize="1" LocationID="30">
Work Center 30 - Debur and PolishThe following instructions pertain to Work Center 30. (Setup hours = 0, Labor Hours = 1, Machine Hours = 0, Lot Sizing = 1)
<step>Using the <tool>standard debur tool</tool> , remove all excess material from weld areas. </step>
<step>Using <material>Acme Polish Cream</material> , polish all weld areas. </step>
</Location>
<Location LaborHours="0.5" LotSize="20" MachineHours="0.65" LocationID="45">
Work Center 45 - Specialized PaintThe following instructions pertain to Work Center 45. (Setup hours = 0, Labor Hours = .5, Machine Hours = .65, Lot Sizing = 20)
<step>Attach <material>a maximum of 20 frames</material>
to <tool>paint harness</tool> ensuring frames are not touching.
</step>
<step>Mix <material>primer PA-529S</material>. Test spray pattern on sample area and correct flow and pattern as required per engineering spec
<specs>AWC-501</specs>. </step>
<step>Apply thin coat of primer to all surfaces.</step>
<step>After 30 minutes, touch test for dryness. If dry to touch, lightly sand all surfaces. Remove all surface debris with compressed air.</step>
<step>Mix <material>paint</material> per manufacturer instructions. </step>
<step>Test spray pattern on sample area and correct flow and pattern as required per engineering spec <specs>AWC-509</specs>.</step>
<step>Apply thin coat of paint to all surfaces.</step>
<step>After 60 minutes, touch test for dryness. If dry to touch, reapply second coat.</step>
<step> Allow paint to cure for 24 hours and inspect per <specs>AWC-5015</specs> . </step>
</Location>
<Location LaborHours="3" LotSize="1" SetupHours="0.25" LocationID="50">
Work Center 50 - SubAssembly The following instructions pertain to Work Center 50. (Setup hours = .25, Labor Hours = 3, Machine Hours = 0, Lot Sizing = 1)
<step>Add Seat Assembly.</step>
<step>Add Brake assembly.</step>
<step>Add Wheel Assembly.</step>
<step>Inspect Front Derailleur.</step>
<step>Inspect Rear Derailleur.</step>
</Location>
<Location LaborHours="4" LotSize="1" LocationID="60">
Work Center 60 - Final Assembly The following instructions pertain to Work Center 60. (Setup hours = 0, Labor Hours = 4, Machine Hours = 0, Lot Sizing = 1)
<step>Perform final inspection per engineering specification
<specs>AWC-915</specs>. </step>
<step>Complete all required certification forms.</step>
<step>Move to shipping.</step>
</Location>
</root>
執行下列查詢以尋找更多的 XML 執行個體：
USE AdventureWorks2008R2;
GO
SELECT Instructions
FROM Production.ProductModel
WHERE Instructions IS NOT NULL;