SQL Server SEQUENCE
In 2012 SQL Server introduced the SEQUENCE object. Looking at the syntax it is very similar to how Oracle has implemented SEQUENCEs for many years.… Read More »SQL Server SEQUENCE
SEQUENCE
Select Favorite SQL Server 2012 Articles
The following articles are a collection of my favorite SQL Server related posts over the last 6 months. 3 Steps to Work More Efficiently in… Read More »Select Favorite SQL Server 2012 Articles
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… Read More »Using a SEQUENCE object to generate letters.
SQL Saturday Presentation
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… Read More »SQL Saturday Presentation
Are you wasting half the capacity of IDENTITY?
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… Read More »Are you wasting half the capacity of IDENTITY?
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… Read More »SEQUENCE Sample Code from SQL Saturday in Olympia WA
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… Read More »TSQL 2012 – Generating letters with a SEQUENCE object
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… Read More »SQL Server 2012 – SEQUENCE
4 Sessions Submitted to Seattle Code Camp
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.… Read More »4 Sessions Submitted to Seattle Code Camp