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() ;

See Also

Reference

SqlHierarchyId Structure

Microsoft.SqlServer.Types Namespace