I have never done any serious SQL design before. Anyways I have to store a hierarchical data structure, similar to a tree in a SQL database. Right now I simply add a "parent_id" column in each of the ...
SQL Server is primarily built around a row-based table structure that connects related data elements in different tables to one another, avoiding the need to redundantly store data in multiple places ...