Create and Manage Data in a Hierarchical Table

Topics covered:
00:00 | Intro
00:39 | Create a database and a table EmployeeOrg
01:48 | Seed initial data
03:18 | IsDescendantOf
05:00 | GetAncestor
06:25 | GetDescendant
10:49 | GetReparentedValue
12:48 | GetLevel
14:04 | Create and execute stored proc PrependEmployee
15:38 | Create and execute stored proc AppendEmployee
16:46 | Create and execute stored proc AddEmployee
18:00 | Create and execute stored proc MoveSubtree

Playlist "SQL Server 2022"
   • SQL Server 2022  #playlist  

Content sources:
https://learn.microsoft.com/en-us/sql...

https://learn.microsoft.com/en-us/sql...