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: , , , , , , ,

SEQUENCE Sample Code from SQL Saturday in Olympia WA

The sample code below is a quick run down of the new sequence object introduced in SQL Server 2012. Just part of my Whats New in TSQL 2012 presentation at SQL Saturday 166.

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

TSQL 2012 – Generating letters with a SEQUENCE object

As shown in my previous posting on SEQUENCES, they are a user-defined object that generates a sequence of numeric values in Transact SQL 2012.  But what if you want to generate letters instead of numbers. Here is a code example of

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