SpecialFlag (clsColumn)

ms132863.note(zh-cn,SQL.90).gif注意:
  下一版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能,并尽快修改当前还在使用该功能的应用程序。

The SpecialFlag property assists the Distribution property in identifying the statistical nature of the column's data values for model optimization purposes.

Data Type

String

Access

Read/write for columns with a SubClassType of sbclsRegular whose IsKey and IsParentKey properties are False, read-only for all others.

备注

For columns whose IsKey or IsParentKey properties are set to True and columns with a SubClassType of sbclsNested, this property returns an empty string.

This property suggests the column contents to the mining model. This suggestion is used to optimize the mining model's MiningAlgorithm and can be left unspecified.

Supported values for this property are listed in the MINING_SERVICES schema rowset in the SUPPORTED_SPECIAL_FLAGS column.

Examples

Building a New Column

The following example builds a new column and sets its SpecialFlag property to PROBABILITY:

Set dsoColumn = dsoNestedCol.Columns.AddNew("pOn Sale")
dsoColumn.SourceColumn = "Sales.pOnSale"
dsoColumn.DataType = adDouble
dsoColumn.RelatedColumn = "On Sale"
dsoColumn.SpecialFlag = "PROBABILITY"

请参阅

参考

clsColumn
MiningAlgorithm (clsMiningModel)

其他资源

Data Mining Schema Rowsets

帮助和信息

获取 SQL Server 2005 帮助