SQL Server 2008 Hierarchy ID data type

Directory

Prepare for Work 1

Exercise: Using HierarchyID data type 2

Preparatory work

Estimated time required to complete this experiment

40 minutes.

Goal

After completing this experiment, you will be able to:

Handling hierarchical ID data types in SQL Server 2008

Prerequisite

Before completing this experiment, you must have:

Experience with writing Transact-SQL scripts and using SQL Server Management Studio.

Experiment scene

SQL Server 2008 allows database applications to build a tree structure in a way that is more efficient than existing methods. HierarchyID is a new type of system that stores values that can represent nodes in a hierarchical tree. This new type provides a very flexible programming model. It is implemented as a CLR UDT and opens up a number of efficient, useful built-in methods for creating and manipulating nodes in the hierarchy.

Virtual Machine Environment

Enable the Microsoft Virtual PC from the Start menu or desktop. If Virtual PC Console is not enabled, check the system tray and double-click the Microsoft Virtual pc in the system tray.

Select Sql08 and click Start.

After the virtual machine is running, you can send a Ctrl+alt+del command to the virtual machine by clicking on the right Alt+del.

In the Login window, enter the following information:

User Name:administrator

password:password01!