I'm trying to create a new database diagram in SQL Server so that I can refer to it for relationships and that sort of thing. I opened SQL Server Enterprise Manager, created a new diagram, added ...

I'm trying to figure out the best (maintainable, efficient, etc.) way to store and retrieve an ordered tree in a SQL database.<BR><BR>I've got an application (C# WinForms) that has a TreeView ...