OrderingMemberProperty (Level Interface)

ms132790.note(zh-tw,SQL.90).gif附註:
  下一版的 Microsoft SQL Server 將不再提供此功能。請勿在新的開發工作中使用此功能,並且儘速修改使用此功能的應用程式。

The OrderingMemberProperty of the Level interface specifies the member property that is used to determine the ordering of level members.

Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel

Data Type

String

Access

Access depends on the value of the ClassType property of the object.

Class type Access

clsDatabaseLevel

R/W*

clsCubeLevel

R

clsPartitionLevel

R

clsAggregationLevel

R

* Read-only for levels with an Ordering of orderKey or orderName.

備註

This property allows the level to be ordered by a member property instead of by name or by key. To order by member property, set the value of the Ordering property to orderMemberProperty, and then set the value of the OrderMemberProperty property to the name of the member property. If the Ordering property of the object is set to orderName or orderKey, this property is read-only, and the value of this property is set to "Name" or "Key", respectively.

請參閱

參考

Level Interface
Ordering (Level Interface)
OrderTypes

說明及資訊

取得 SQL Server 2005 協助