SQL Server hierarchyID is a built-in data type designed to represent trees, which are the most common type of hierarchical data. Each item in a tree is called a node. However, before we dive into the peculiarities of using SQL Server hierarchyID, let’s clarify its meaning and scope. In this article, we are going to find out about all those excellent opportunities. It is a better-looking code, but it has much more in it. However, when I finally did it, I found it a great innovation. The truth is, I didn’t explore this option since it was released. If you never explored this option, it might be surprising for you. You may wonder what difference it makes and which benefits you get from using hierarchyID instead of the usual parent/child relationships. But note that Microsoft added this feature to represent one-to-many relationships with multiple levels in a better way. Of course, the novelty itself is not a persuasive argument. Do you still hold on to the parent/child design, or would like to try something new, like SQL Server hierarchyID? Well, it is really new because hierarchyID has been a part of SQL Server since 2008.
0 Comments
Leave a Reply. |