SQL Server - Discovering HierarchyId data type

The hierarchyid type was introduced with SQL Server 2008. This type is used to represent and manipulate hierarchical data. Hierarchical data contain the notion of parent / child but also the notion of order between elements having the same parent. Values ​​of this type are actually stored in a binary form, for example 0x5AC0 or 0x58, but in practice we use character strings of the type '/' for the root or… [read more]