Sequence next value in SELECT statement

If you want to select the next value from sequence object, you can use this SQL statement.

SELECT NEXT VALUE FOR [dbo].[seq_Vehicles] AS NextVehicleId

If you want to select multiple next values from SQL Sequence, you have to loop calling the above SQL statement and save the "next value" got in a storage.

You can loop using (while loop) or by (cursor).

Don't use a sub-select:

SELECT col1, co2, col3, TEST_SEQ.NEXTVAL as SEQ
FROM table;