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