createstructurewithnestedtable.dmx

来自「< SQL Server2005程序设计>」· DMX 代码 · 共 9 行

--Create a new mining structure
--Using Association Rules algorithm and nested table syntax
CREATE MINING MODEL PurchaseAssociations(
  [Customer Key] LONG KEY
  ,[Customer Purchases] TABLE PREDICT
    (
      [Product Subcategory] TEXT KEY 
     )
) USING Microsoft_Association_Rules