Hierarchical Database Systems

**areejan2000@yahoo.com** · Nov 13 '05, 04:00 PM

Hierarchical Database Systems

there are a lot of articles which are SQL server related

http://www.devx.com/tips/Tip/22127

For those who may not know this, you can have an optional Parameter in SQL. It took me forever to figure it out.

http://www.codeproject.com/database/nestedsets.asp

google groups "Get Data Recursively"

how to retrieve/delete a node in the following table based on MS ACCESS
Vb.

ID Item ParentId
1 Electronics 0
2 Blender 1
3 Cosmetics 0
4 DVD player 5
5 Sony 1
6 Sharp 1
7 Johnson & Johnson 3
8 Face Cream 7
9 Flat TV 5
10 Baby Oil 7

could a pro explain this in simple plain english for an intermediate
user?