SqlHierarchyId.GetRoot Method ()

Article
07/16/2015

Applies To: SQL Server 2016 Preview

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

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

public:
[SqlMethodAttribute(DataAccess = DataAccessKind::None, SystemDataAccess = SystemDataAccessKind::None, 
    InvokeIfReceiverIsNull = false, OnNullCall = false, IsDeterministic = true, 
    IsPrecise = true, IsMutator = false)]
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

<SqlMethodAttribute(DataAccess := DataAccessKind.None, SystemDataAccess := SystemDataAccessKind.None,
    InvokeIfReceiverIsNull := False, OnNullCall := False, IsDeterministic := True,
    IsPrecise := True, IsMutator := False)>
Public Shared Function GetRoot As 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

Legacy Code Example

SELECT HierarchyID::GetRoot() ;