Predict
Collapse the table of content
Expand the table of content

Predict

SQL Server 2000

Predict

Returns a value of a numeric expression evaluated over a data mining model.

Syntax

Predict(«Mining Model Name», «Numeric Expression»)

Remarks

The Predict function evaluates the numeric expression specified in «Numeric Expression» in another data mining model, within the context of the mining model specified in «Mining Model Name».

Data mining syntax and functions are documented in the OLE DB for Data Mining specification. For more information about the OLE DB for Data Mining specification, see the Microsoft OLE DB Web page at the Microsoft Web site.

Example

The following code returns the variance value for the histogram entry in the [Gender] data mining column that has the highest probability in the Customer Pattern Discovery data mining model:

Predict("Customer Pattern Discovery","PredictVariance([Customer Pattern Discovery].[Gender])")
Show:
© 2016 Microsoft