New answers tagged sequence
As per the documentation states: The NEXT VALUE FOR function is nondeterministic, and is only allowed in contexts where the number of generated sequence values is well defined. Below is the definition of how many values will be used for each referenced sequence object in a given statement: SELECT - For each referenced sequence object, a new value is ...
There is a known issue in some circumstances. As far as I can see, you need to use NO CACHE so numbers cannot be reused
Top 50 recent answers are included