How Do I: Using the HierarchyID Data Type in SQL Server 2008 to manage data hierarchies?

Managing hierarchies in Information Systems has long been a challenge to most information systems professionals. The issues are simple, but the implementation of hierarchies within databases is complex and often onerous. The HierarchyID datatype introduced in SQL Server 2008 provides a new way to deal with these types of issues. In this video, Max Adams will introduce this new HierarchyID Datatype and examine how to:
-Create tables that implement this datatype
-Populate the table with data using CTE
-Query the table using some of the inherent functions available for the HierarchyID Datatype

Read more: http://technet.microsoft.com/en-us/sqlserver/dd935859.aspx

Add this page to your favorite website

Comments

Add New Search

Write comment
Name:
Email:	do not notifynotify
Website:
Title:
UBBCode:	-color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge
	Please input the anti-spam code that you can read in the image.

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."