Tag: Cycle No Cycle

Using a SEQUENCE object to generate letters.

SQL Server 2012 introduces a new T-SQL object used to generate numbers, a SEQUENCE, similar to an identity column. You can think of a sequence as a take a number object, you just ask it to give you a number, and you get

Posted in TSQL, TSQL 2012 Tagged with: , , , , , , ,

SQL Server 2012 – SEQUENCE

SQL Server 2012 introduces the SEQUENCE object.  Looking at the syntax it is very similar to how Oracle has implemented SEQUENCEs for many years.  I believe that the SEQUENCE was introduced to aid in the transition of Oracle developers to

Posted in SQL 2012 Tagged with: , , , , ,