SqlHierarchyId.GetReparentedValue Method
Gets a value representing the location of a new SqlHierarchyId node that has a path from newRoot equal to the path from oldRoot to this, effectively moving this to the new location.
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 GetReparentedValue ( _
oldRoot As SqlHierarchyId, _
newRoot As SqlHierarchyId _
) As SqlHierarchyId
'Usage
Dim instance As SqlHierarchyId
Dim oldRoot As SqlHierarchyId
Dim newRoot As SqlHierarchyId
Dim returnValue As SqlHierarchyId
returnValue = instance.GetReparentedValue(oldRoot, _
newRoot)
[SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public SqlHierarchyId GetReparentedValue(
SqlHierarchyId oldRoot,
SqlHierarchyId newRoot
)
[SqlMethodAttribute(DataAccess = DataAccessKind::None, SystemDataAccess = SystemDataAccessKind::None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public:
SqlHierarchyId GetReparentedValue(
SqlHierarchyId oldRoot,
SqlHierarchyId newRoot
)
[<SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)>]
member GetReparentedValue :
oldRoot:SqlHierarchyId *
newRoot:SqlHierarchyId -> SqlHierarchyId
public function GetReparentedValue(
oldRoot : SqlHierarchyId,
newRoot : SqlHierarchyId
) : SqlHierarchyId
Parameters
- oldRoot
Type: Microsoft.SqlServer.Types.SqlHierarchyId
An ancestor of the SqlHierarchyId node specifying the endpoint of the path segment that is to be moved.
- newRoot
Type: Microsoft.SqlServer.Types.SqlHierarchyId
The SqlHierarchyId node that represents the new ancestor of this.
Return Value
Type: Microsoft.SqlServer.Types.SqlHierarchyId
A SqlHierarchyId node representing the new hierarchical location of this. Will return nulla null reference (Nothing in Visual Basic) if oldRoot, newRoot, or thisare nulla null reference (Nothing in Visual Basic).
Remarks
Returns a node whose path from the root is the path to newRoot, followed by the path from oldRoot to this.
The SqlHierarchyId data type represents but does not enforce the hierarchical structure. Users must ensure that the SqlHierarchyId node is appropriately structured for the new location.