createmodelwithnestedtable.dmx

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

--Nested table syntax in DMX
ALTER MINING STRUCTURE CustomerProfitCategory
ADD MINING MODEL ProductBuyer_DT(
  [Customer Key]
  ,[Age]
  ,[Commute Distance]
  ,[English Education]
  ,[Gender]
  ,[Income Group]
  ,[Is Car Owner] 
  ,[Region]
  ,[v Customer Purchases] PREDICT
    (
      [Product Category] 
    )
) USING Microsoft_Decision_Trees