Next Value For Clause
Purpose
Use the Next Value For clause to specify the next value for a sequence that is used in a Select, Insert, or Update statement.
Syntax
NEXT VALUE FOR sequence_name
where:
sequence_name
specifies the name of the sequence from which to retrieve the value.
Example
The following example retrieves the next value or set of values in Sequence1:
SELECT NEXT VALUE FOR Sequence1 FROM Account
