RootIfValues

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

Enumerates values for the RootMemberIf property.

Constant Description

rootifParentIsBlank

Only members with a null, a zero, or an empty string in their ParentKeyColumn are treated as root members.

rootifParentIsBlankOrSelfOrMissing

Members are treated as root members if they meet one or more of the conditions specified by rootifParentIsBlank, rootifParentIsSelf, or rootifParentIsMissing.

rootifParentIsMissing

Only members with parents that cannot be found are treated as root members.

rootifParentIsSelf

Only members with themselves as parents are treated as root members.