Main Content

What Sequence objects are (and are not)

About the Talk

May 12, 2012 12:30 PM

Jefferson State Community College Shelby-Hoover Campus

Jefferson State Community College Shelby-Hoover Campus

SQL Server 2012 adds a new object to our arsenal called a sequence that can will give us the capability to implement automatically incrementing values. However, it cannot replace a lot of functionality that we have used a numbers table and windowing functions for (though they can be complimentary to one another). In this session I will demonstrate the uses and performance characteristics of sequences, including how they compliment the use of number tables and windowing functions to create surrogate key and sorting values, and more.

Ratings and Recommendations

Avg. Rating

Average based
on 3 ratings

comments powered by Disqus