hierarchyid Data Type Method Reference
Applies To: SQL Server 2014, SQL Server 2016 Preview
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
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.