How to Use SQL Server HierarchyID Through Easy Examples

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. Of course, the novelty itself is not a persuasive argument. But note that Microsoft added this feature to represent one-to-many relationships with multiple levels in a better way.

--

--

--

Awesome blog focused on databases and Microsoft, .NET and cloud technologies. http://codingsight.com/

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

OTA Firmware Update on Arduino

GIT: It is never too late to ignore files

How To Remote Debug Ballerina Compiler

Why we use dictionary in python?

Why your production REST APIs are incoherent and messy?

Azure Introduction

Lens Studio Basics — Importing External Audio

symbiotik Token Presale Starts Soon

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
{coding}Sight

{coding}Sight

Awesome blog focused on databases and Microsoft, .NET and cloud technologies. http://codingsight.com/

More from Medium

SQL: An Overview

STORED PROCEDURES IN SQL SERVER

SQL - JOINS

How to sort result set in custom order in SQL?