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).
This tutorial is intended for users who are experienced with Transact-SQL, but are new to the hierarchyid data type.
In this lesson, you take an existing employee table that is structured as a parent/child hierarchy and move the data into a new table that represents the hierarchy by using the hierarchyid data type. This lesson requires the