Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
GetRoot (Database Engine)

GetRoot (Database Engine)

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:


Community Additions

© 2015 Microsoft