Tagged Questions
4
votes
2answers
140 views
Transactions, references and how to enforce double entry bookkeeping? (PG)
Double entry bookkeeping is
a set of rules for recording financial information in a financial
accounting system in which every transaction or event changes at least
two different nominal ...
1
vote
2answers
674 views
SQL Server 2008 R2 - How to check Foreign Key constraints in a transaction only when committed?
We are synchronizing tables between two databases (yes, it needs to be done by our software and not by replication etc.)
Both databases are identical with many foreign-key constraints on tables.
...