transitive-closure-table
update table based on subquery of table
I have am using a closure table for some page heirarchy. I want to be able to delete a page and update the level of the children it leaves.[详细]
2023-04-06 01:30 分类:问答What's the best way to update a closure table?
I have a table relating records using the adjacency list method (table A), and another table relating the same records using a closure table (table B).They both capture the same graph, so they both ne[详细]
2023-02-23 07:48 分类:问答How can I speed up queries that are looking for the root node of a transitive closure?
I have a historical transitive closure table that represents a tree. create table TRANSITIVE_CLOSURE ( CHILD_NODE_ID number not null enable,[详细]
2023-02-15 22:00 分类:问答mySQL transitive closure table
I have some code I\'ve been using in SQL Server to generate a closure table from another table that has just the direct parent/child relationships, I can run very simple queries against this to determ[详细]
2023-01-26 11:29 分类:问答Duplicate a database record with linq
Is there a way to duplicate a db record with linq to sql in c#? Id [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,[详细]
2022-12-24 10:02 分类:问答