SQL Sequence | Just Simply Code

Resetting SQL Sequence for multiple test environments

26 September 2021 / Leave a Comment

In the last post, I showed how we use SQL Sequence to achieve sequential number ID in a specific range. As mentioned in the last post, we and each party that we integrate with have a defined range of number to be used as ID and this ID must be unique globally among all the … [Read more…]

Using SQL Sequence

12 September 2021 / Leave a Comment

Recently we have a requirement for one project where the ID for any entities in this project must be within a range of number. In this project, we have to integrate with a number of other external parties. The ID for any entity used in this integration must be unique globally across all the connected … [Read more…]