SQL Server 2012 T-SQL - Working with Sequence

One of the T-SQL enhancemtns in SQL Server 2012 addition of Sequence.  You can use sequence to generate a sequential number that can use utilized for various purpose. Here is simple example of using Sequence to populate sequential number to a table.    Create Table dbo.Employee ( EmployeeID Int, FirstName Varchar(30) ); Create Sequence dbo.EmpIDSeq As Int Start with…

0