This topic has not yet been rated - Rate this topic

hierarchyid Data Type Method Reference

SQL Server 2012

SQL Server 2008 R2
SQL Server 2008

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.

In This Section

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)

Reference

hierarchyid (Transact-SQL)

Concepts

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

ADD