SqlHierarchyId.GetDescendant 메서드

SQL Server 2012

Gets the value of a descendant SqlHierarchyId node that is greater than child1 and less than child2.

네임스페이스:  Microsoft.SqlServer.Types
어셈블리:  Microsoft.SqlServer.Types(Microsoft.SqlServer.Types.dll)

[SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, 
	InvokeIfReceiverIsNull = false, OnNullCall = true, 
	IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public SqlHierarchyId GetDescendant(
	SqlHierarchyId child1,
	SqlHierarchyId child2
)

매개 변수

child1
유형: Microsoft.SqlServer.Types.SqlHierarchyId
The lower bound.
child2
유형: Microsoft.SqlServer.Types.SqlHierarchyId
The upper bound.

반환 값

유형: Microsoft.SqlServer.Types.SqlHierarchyId
A SqlHierarchyId with a value greater than the lower bound and less than the upper bound.

  • If parent is null, returns null.

  • If parent is not null, and both child1 and child2 are null, returns a descendant of parent.

  • If parent and child1 are not null, and child2 is null, returns a descendant of parent greater than child1.

  • If parent and child2 are not null and child1 is null, returns a descendant of parent less than child2.

  • If parent, child1, and child2 are not null, returns a descendant of parent greater than child1 and less than child2.

  • An exception is raised if child1 or child2 are not null and are not a descendant of parent.

  • If child1 >= child2, an exception is raised.

커뮤니티 추가 항목

추가
표시: