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 |
|
trygvis
Starting Member
7 Posts |
 Posted - 2000-12-14 : 10:16:54
|
Im tring to create a link collection. A link can have a father dir, any link can be a directory.This is my table:quote:
CREATE TABLE Link( id INTEGER NOT NULL PRIMARY KEY, linkID INTEGER NOT NULL REFERENCES Link(id), tag VARCHAR(255) NOT NULL, url VARCHAR(255), description VARCHAR(255), dateAdded DATETIME NOT NULL );
I have some queries i want to make:1. How can I get all parent directories to one dir?2. How can I count all sub links of a link?3. When I want to see all links in a dir, is there any way to see if a links has any child links? |
|
|
|
|
|
A linkdirectory