#眉標=SQL Server 2005
#副標=資料庫管理的大變革
#大標= SQL Server 2005商業智慧新功能
#作者=文／楊志強

程式1
--查詢輸出的欄位
SELECT
  [Promotions DS].[Buy],  t.[CustID], 
  PredictProbability([Promotions DS].[Buy]), 
--預測購買的機率

  t.[CustName],  t.[EmailAddress],
  t.[SameTelecom],  t.[YearIncome]
From
--透過資料庫的潛在客戶資料表與採礦模型
--進行查詢
  [Promotions DS] PREDICTION JOIN
  OPENQUERY([Tele Com],
    'SELECT
      [CustID], [CustName], [EmailAddress], 
[SameTelecom], [YearIncome], [ARPU], 
[Gender]
    FROM
      [dbo].[vCustomers] ') AS t
ON
  [Promotions DS].[Year Income] = t.[YearIncome] 
AND  [Promotions DS].[ARPU] = t.[ARPU] 
AND  [Promotions DS].[Gender] = t.[Gender]
AND  [Promotions DS].[Same Telecom] 
= t.[SameTelecom]