GetRoot (Database Engine)
Returns the root of the hierarchy tree. GetRoot() is a static method.
Syntax
-- Transact-SQL syntax
hierarchyid::GetRoot ()
-- CLR syntax
static SqlHierarchyId GetRoot ()
Return Types
**SQL Server return type:**hierarchyid
**CLR return type:**SqlHierarchyId
Remarks
Used to determine the root node in a hierarchy tree.
Examples
A. Transact-SQL example
The following example returns the root of the hierarchy tree:
SELECT OrgNode.ToString() AS Text_OrgNode, *
FROM HumanResources.EmployeeDemo
WHERE OrgNode = hierarchyid::GetRoot()
B. CLR example
The following code snippet calls the GetRoot() method:
SqlHierarchyId.GetRoot()