Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-19 : 23:48:49
|
Wallace writes "I have a database table to store a hierarchical tree structure, like the directory structure in C drive.
CREATE TABLE tblFolders(
ID INT AUTO_INCREMENT PRIMARY KEY,
Name VARCHAR(100),
ParentID INT
);
My questions:
1. Is it posible to use only a single database call to retrieve the tree, given the ID of the leaf node?
2. Is there a more efficient way to design the database to store this kind of structure?" |
|
|
|
|
|
SQL for Hierarchical Data Structure