hierarchical-data
Semi-structured database setup for ASP.NET 3.5
What would be the best database setup for a small \"contact management\" type website? It is going to be used internally only (intranet), and I\'m using ASP.NET 3.5 and SQL Server.[详细]
2023-02-16 01:24 分类:问答How to store and search for a sequence in a RDBMS?
I need to store some sequences/lists in the database (SQL Server 2008), and then find the ID for a particular sequence from the DB if any exists.[详细]
2023-02-14 17:51 分类:问答Recommendations for implementing a complex schema in SQL Server using XML Type
My application has a complex schema for the domain entity. It is required use SQL Server 2008. Following are the complexities:[详细]
2023-02-14 14:28 分类:问答how do i go from a datatable to a hierarchical structure in asp.net c#
I have a datatable which i get from the databasemanager class, and i would need to transform that data into a hierarchical structure[详细]
2023-02-12 19:40 分类:问答SQL Server Tree Query
I need some help is MS SQL Server Query. I’m not much of a DBA.I have an application with an Organization Table which is made up of a parent-child relationship:[详细]
2023-02-10 23:11 分类:问答Dealing with recursion (oracle)
开发者_StackOverflow中文版I\'m a having some problems trying to do some business logic for a client (web trading):[详细]
2023-02-10 18:23 分类:问答How to find distinct root-nodes of newest nodes in trees (hold in closure table)?
I try to store tree of messages as closure table on MySQL. Mostly learned about this method from Bill Karwin\'s presentation Models for hierarchical data. Problem is: i want to find distinct 3 root no[详细]
2023-02-09 23:13 分类:问答Make hierarchy in PHP array in cycle
I\'ve been fighting for hours with such a problem. For speeding my web-page I request database to get all categories just one time and then want to sort the array using PHP.[详细]
2023-02-07 13:50 分类:问答Need to convert a recursive CTE query to an index friendly query
After going through all the hard work of writing a recursive CTE query to meet my needs, I realize I can\'t use it because it doesn\'t work in an indexed view.So I need something else to replace the C[详细]
2023-02-07 04:53 分类:问答How to JOIN these 2 tables together (MySQL, Hierarchical query)?
I have a categories table that looks like this: id | name| parent ----------------------- 1| Toys| 1 2| Clothing| 1[详细]
2023-02-06 20:44 分类:问答