This topic has not yet been rated - Rate this topic

GetRoot (Database Engine)

SQL Server 2012

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.

The following example returns the root of the hierarchy tree:

SELECT OrgNode.ToString() AS Text_OrgNode, *
FROM HumanResources.EmployeeDemo
WHERE OrgNode = hierarchyid::GetRoot()

The following code snippet calls the GetRoot() method:

SqlHierarchyId.GetRoot()

hierarchyid (Transact-SQL)

hierarchyid Data Type Method Reference

Hierarchical Data (SQL Server)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions