Export (0) Print
Expand All

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)

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


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

Return Value

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

parent is considered its own descendant.

Community Additions

© 2014 Microsoft