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

See Also

Reference

hierarchyid (Transact-SQL)

Concepts

hierarchyid Data Type Method Reference

Hierarchical Data (SQL Server)