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 …

Using a SEQUENCE object to generate letters. Read more »

I am at SQL Saturday in Vancouver BC today. Here is the download of my presentation. Download zip file. Here is the presentation outline. OVER Clause Enhancements ROWS PRECEDING, FOLLOWING, UNBOUNDED RANGE PRECEDING, FOLLOWING, UNBOUNDED IIF – Immediate IF or …

SQL Saturday Presentation Read more »

When creating a table you can specify IDENTITY with the following syntax: For example The IDENTITY property is valid for data types of the integer data type category, except for the bit data type, or decimal data type.  So how …

Are you wasting half the capacity of IDENTITY? Read more »

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 …

TSQL 2012 – Generating letters with a SEQUENCE object Read more »

It has been a busy week getting ready for  SQL Saturday Vancouver, planning sessions to present at future training’s and determining new material to present. Today I submitted 4 sessions to Seattle Code Camp for their June session. Using SSRS …

4 Sessions Submitted to Seattle Code Camp Read more »