SqlHierarchyId.GetRoot Method
Gets a value representing the root SqlHierarchyId node of the hierarchy.
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 Shared Function GetRoot As SqlHierarchyId
'Usage
Dim returnValue As SqlHierarchyId
returnValue = SqlHierarchyId.GetRoot()
[SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public static SqlHierarchyId GetRoot()
[SqlMethodAttribute(DataAccess = DataAccessKind::None, SystemDataAccess = SystemDataAccessKind::None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public:
static SqlHierarchyId GetRoot()
[<SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)>]
static member GetRoot : unit -> SqlHierarchyId
public static function GetRoot() : SqlHierarchyId
Return Value
Type: Microsoft.SqlServer.Types.SqlHierarchyId
A SqlHierarchyId representing the root node of the hierarchical tree.Root value is typically 0x.
Remarks
This member is static.
Examples
SELECT HierarchyID::GetRoot() ;