In documentation it is told that:
Duplicate validation only occurs once a record is fully populated. This can result in some cases where the same number is used for more than one record during creation, but then gets identified as a duplicate
I do NOT want to use that number in an insert query like this:
INSERT Test.Orders (OrderID, Name, Qty) VALUES (NEXT VALUE FOR Test.CountBy1, 'Tire', 2) ;
I want to obtrain that number in my web application and use it to construct a ciphered text. and store the ciphered code in database. Hence, in my case, there is no duplicate checking while inserting.
The thing I need to know is that whether it is probable for two clients calling
NEXT VALUE FOR function nearly at the same time, and get the same values? or not? (I need this not to happen)