Sequence: New Feature in SQL 2012

Sequence is an user defined object that generates a sequence of a number. 



/****** Create new Sequence Object ******/
 CREATE SEQUENCE FirstSequence
 START WITH 1
 INCREMENT BY 1;



/****** Create Temp Table ******/
 DECLARE @Employee TABLE
 (
 ID int NOT NULL PRIMARY KEY,
 Employee nvarchar(100) NOT NULL
 );


/****** Insert Some Data ******/
 INSERT @Employee (ID, Employee)
 VALUES (NEXT VALUE FOR MySequence, 'Maha'),
 (NEXT VALUE FOR MySequence, 'Sam'),
  (NEXT VALUE FOR MySequence, 'Ram');


/****** List the Data ******/
SELECT * FROM @Employee;


The output will be as follows:-------------
ID  Employee
-------------
1 Maha
2 Sam
3 Ram
-------------