SqlHierarchyId.IsDescendantOf Method

Gets a value indicating whether the SqlHierarchyId node is the descendant of the parent.

Namespace:  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

Syntax

'Declaration
<SqlMethodAttribute(DataAccess := DataAccessKind.None, SystemDataAccess := SystemDataAccessKind.None,  _
    InvokeIfReceiverIsNull := False, OnNullCall := False,  _
    IsDeterministic := True, IsPrecise := True, IsMutator := False)> _
Public Function IsDescendantOf ( _
    parent As SqlHierarchyId _
) As SqlBoolean
'Usage
Dim instance As SqlHierarchyId
Dim parent As SqlHierarchyId
Dim returnValue As SqlBoolean

returnValue = instance.IsDescendantOf(parent)

[SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, 
    InvokeIfReceiverIsNull = false, OnNullCall = false, 
    IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public SqlBoolean IsDescendantOf(
    SqlHierarchyId parent
)

[SqlMethodAttribute(DataAccess = DataAccessKind::None, SystemDataAccess = SystemDataAccessKind::None, 
    InvokeIfReceiverIsNull = false, OnNullCall = false, 
    IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public:
SqlBoolean IsDescendantOf(
    SqlHierarchyId parent
)

[<SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, 
    InvokeIfReceiverIsNull = false, OnNullCall = false, 
    IsDeterministic = true, IsPrecise = true, IsMutator = false)>]
member IsDescendantOf : 
        parent:SqlHierarchyId -> SqlBoolean

public function IsDescendantOf(
    parent : SqlHierarchyId
) : SqlBoolean

Parameters

• parent
  Type: Microsoft.SqlServer.Types.SqlHierarchyId
  The specified SqlHierarchyId node for which the IsDescendantOf test is performed.

Return Value

Type: System.Data.SqlTypes.SqlBoolean
Boolean , true (1) for all the nodes in the sub-tree rooted at parent; false (0) for all other nodes.

Remarks

parent is considered its own descendant.

See Also

Reference

SqlHierarchyId Structure

Microsoft.SqlServer.Types Namespace