SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

GetRoot (Database Engine)

SQL Server 2008

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

Copy 

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

-- 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:

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

B. CLR example

The following code snippet calls the GetRoot() method:

Copy 
SqlHierarchyId.GetRoot()
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.