Let us first create a sequence as
CREATE SEQUENCE GenerateSequence
START WITH 1
INCREMENT BY 1;
After execution of this statement, we will find in the Sequences node a sequence object has been created.Once the sequence object is in place, we can create a table and populate it with the values
Create Table tblSequence
(
SequenceID int not null primary key
,SequenceData varchar(20) not null
);
Insert into tblSequence(SequenceID , SequenceData )
VALUES (NEXT VALUE FOR GenerateSequence, 'Data1'),
(NEXT VALUE FOR GenerateSequence, 'Data2')
SELECT * FROM tblSequence