| Below are the different format used by hierarchyid to represent
tree structure data.
(1)All data in hierarchyid column type is start with "/" and end
with "/"
(2)Top level always represent with "/"
(3)first level after the top level is used "/1". And more level in first level is represent by "/2".
(4)If we have to insert value on second level we use "/1/1/" | | |