GetRoot (Database Engine)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns the root of the hierarchy tree. GetRoot() is a static method.

  
-- Transact-SQL syntax  
hierarchyid::GetRoot ( )   

  
-- CLR syntax  
static SqlHierarchyId GetRoot ( )   

SQL Server return type:hierarchyid

CLR return type:SqlHierarchyId

Used to determine the root node in a hierarchy tree.

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

hierarchyid Data Type Method Reference
Hierarchical Data (SQL Server)
hierarchyid (Transact-SQL)

Community Additions

ADD
Show: