SQL Server 2008 supports a set of methods for the Transact-SQL hierarchyid data type and the common language runtime (CLR) SqlHierarchyId class. For more information, see Working with hierarchyid Data. 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)

 See Also

Reference

hierarchyid (Transact-SQL)

Other Resources

Tutorial: Using the hierarchyid Data Type
Using hierarchyid Data Types (Database Engine)

Help and Information

Getting SQL Server 2008 Assistance