Tutorial: Using the hierarchyid Data Type

This tutorial is intended for users who are experienced with Transact-SQL, but are new to the hierarchyid data type.

What You Will Learn

This tutorial is divided into two lessons:

Requirements

Your system must have the following installed:

  • Any edition of SQL Server 2008 or later.

  • Either SQL Server Management Studio or Management Studio Express.

  • Internet Explorer 6 or a later version.

Note

When you review the tutorials, we recommend that you add the Next and Previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.

See Also

Reference

hierarchyid (Transact-SQL)

Concepts

Tutorial: Getting Started with the Database Engine

Tutorial: Writing Transact-SQL Statements

hierarchyid Data Type Method Reference

Hierarchical Data (SQL Server)

Other Resources

Tutorials