How to get unique, non-overlapping, contiguous ranges, usable by concurrent sessions? An example use-case might be that multiple threads need to retrieve a range of ID values that have not been used yet (are unique), are contiguous (no gaps), and without any overlaps. This example makes use of a mutex...
[Read More]
Enforce Single Row Table
How to enforce that a table contains at most one row?
[Read More]