hierarchyid Data Type Method Reference


SQL Server supports a set of methods for the Transact-SQL hierarchyid data type and the common language runtime (CLR) SqlHierarchyId class. For more information, see Hierarchical Data (SQL Server).

The topics in this section provide the syntax and examples for each hierarchyid data type method.

GetAncestor (Database Engine)

GetDescendant (Database Engine)

GetLevel (Database Engine)

GetRoot (Database Engine)

IsDescendantOf (Database Engine)

Parse (Database Engine)

Read (Database Engine)

GetReparentedValue (Database Engine)

ToString (Database Engine)

Write (Database Engine)

Hierarchical Data (SQL Server)
hierarchyid (Transact-SQL)

Community Additions