hierarchyid data type method reference

data-types

#tsql#data-types

hierarchyid

Extremely compact

Comparison is in depth-first order

hierarchyid

Support for arbitrary insertions and deletions

Encoding is limited to 892 bytes: hierarchyid

hierarchyid